Thank you, Abraham. Your suggestions of table modifications makes the query problem a whole lot easier. I didn't look at it that way before. I will give it...
I have been asked to build a database and I have attempted to do just that, I have a single primary table called building and three secondary tables. The...
I am using DMax function for my custom autonumber I just realized that when using this in a multi user environment, I am getting duplications. This field is...
Hi Vishwa, Maybe you need to reset CheckBlank to False before running ValidateData or before running whichever process sets it to true. Abraham ... return's ...
Hi again, I downloaded some software that sems to work. You can restrict access to a folder except for MSAccess or whichever program you choose. It's called...
Ron, Field named Location in the first table (PeopleTbl) is sufficient. No need to have the same field in the second table (MeetingsTbl). Sample query given...
Aj, I have just downloaded the file (on 03Oct05). It still looks like a snakes nest but will see if I can make sense of it. It will probably take weeks rather...
I have a continuous subform within a form. I would like to be able to change the focus in my subform, if the cursor lands on another form. My code is: ...
Clive, Thanks again. I'm still trying to figure it out, but I'm spending less and less time on it before my head starts hurting and I switch to something...
Doug, I didn't catch the name of your main form, with that in mind, here goes. Main form name: Mainform Sub form name: frm_Attendance_Subform Field Name:...
Good Afternoon all, I am in the midst’s of building a database to take the place of everyone's Microsoft scheduler routines. As not to bore you with the...
Darrell, I have been browsing through several books and web pages for imformation on that exact subject. So far I have only found examples that will allow me...
Kris Running code from another database will work if the code is public and in a standard module, not in a form or report class module. First, open the code...
Not sure what you are trying to achieve with the schema, if you just want to validate xml versus the external schema file , this will work. on xml 5.0 or maybe...
According to Woodyswatch.com there are issues with Office 2003 SP2. We recommend waiting until these issues are resolved before installing SP2. A direct quote...
Hi, I need some code to map a network folder \\ServerName\SharedDrive as Drive G: for instance. Any code that can do that? To take it a step further, I may...
I'm not experienced in Access and database programs yet, but I know the basics. How can I associate a field of records with specific notes that may contain a...
Hi guys, I have a problem with Picture field on ACCESS. One of my client is a Photographer. He has collection of picture for each customer. So let say Cust A...
I hope I have the right list ... One of the Access groups I read has a Switchboard proponent/expert on it. I have noticed that I intermittently have client PCs...
I have two problems I need to get solved. 1. I have to put information from two tables in a form One field from one form is searchable and it should populate...
Steve Don't use sw... oops! Brett is probably the switchboard expert you were looking for, but I'll attempt to offer some help. When an app works fine on one...
Nathen You could store the text file's path in the table. Maybe even use a hyperlink to open the text file on demand. Regards, Bill Mosca Founder ... know ... ...
Thank you. I've printed this out and will try to figure it out. What I am "trying to achieve with the schema" is generate a report from Access2003 (bought...
Alex There is a sample database in our Files section called LoadPictureSample.zip. It shows you how to display an image that is a file outside of the database....
Hello... I am getting this strange error and it is driving me insane. There is this database that I am going to call "HeadAche". When I open this HeadAche a...
Chuck Just a shot in the dark, but since this will only work when you have the database opened exclusively (design view), are you making any design changes to...
Well my boss just figured it out for me... Strangley enough when he set the popup to false on the form it worked fine. I got no idea why that would cause the...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
