We are a non-profit organization that keeps all our membership info in an Access Database. We would like to be able to put the back-end(data) in a centralized...

my calculation is: (((w * l)*2)/1.8)*x The answer MUST return an even number. I can do this in Excel, can't find a way in Access. Help!

I would like to manage multiple database switchboards from one central switchboard. Is that possible?

hi i wanted to know if i could do something a bit "web page" with my switchboard. i want to make the buttons transparent, lay an image on top & operate buttons...

1) Are the fields on your form all unbound or are they in another table? Either way, you can make a Make Table query where the criteria line would contain the...

Hi When I try to run access 97 I get the message 'Microsoft Access couldn't find file c:\windows\system32\system.mdw'. When I try to create the system.mdw...

Good evening, I have a form in which I can add records. I would like to limit the number of records to two. Is there a (simple) way to do that, as I...

Hi I have a table with fields, building (text), to (number), from (number). How do I pull down a record with, let's say the criteria of: Building= "A" and...

*If you know of a posting that can assist me, please advise. Otherwise, let me know if you have a suggestion for this. I have a table set-up with about 20...

I have to create a Microsoft Access 97 database (with a SQL Server back-end) which acts as a quotation engine for an insurance company. The problem I have is...

If you'd scrolled through the list you get when you use the Tools|References menu command in the VB Editor you would have found the "Microsoft Office Document...

I have customer data I've imported into Access, and one of my Update queries converts the person's last name to proper case (so that SMITH becomes Smith, for...

Hello experts, I've posted this question twice already without a single response. I'm very suprised because it doesn't seem like that difficult of a problem ....

Is it possible to copy my existing form so that the commands are not also copied? I have over 4,000 commands. I noticed this when I entered a new command...

Does anyone know whether the Compact On Close option is limited to the MS Access user interface (UI) or whether it applies to the Jet database layer? This...

I have a tracking form with 4 combo boxes. Combo1 and 2 are linked, the option chosen in Combo1 drives the options displayed in Combo2. Combo3 and 4 are...

Hello All I hope these are appropriate newsgroups for my query - if not I would be very grateful if someone could tell me where to go! I currently have a...

Hi All, I want to set up a validation rule to restrict entries on a text field to the folloiwng format: Friday, 4 April 2005 Thursday, 11 January 2005 Any...

It seems that no matter where I put my page breaks on a form, covering 181 separate records, although the second page does start at the correct point, I can't...

Hello! I have a form based in T_Imgs with unbound combobox and two bound textbox. When we open the form the combo is empty but the two textbox show us the...