Search results

I double checked the table and it is set as a Date/Time field. This is the criteria I currently have in place: Like [Enter Date:] I have tried a couple of different things and can't get it to work properly!

I have a query where one of the searchable fields is the date. The issue I am having is that if the date is not entered in the query exactly as it was entered in the table, it won't pull back the information. Is there a way to set up the criteria in the query to accept the date in any format...

I have reloaded Access 2003 on my machine and I have all elements in the 2003 database, but the switchboard is still giving me problems. Whenever I go in and set it up using either the macros I have desiged or I use the functions given in the drop down boxes when creating the switchboard I get...

If it is only available in 2007 why is it popping up the prompt in 2003 and when I go in to 2007 it doesn't show any TempVars? Is there anyway I can take it out? The Help button mentioned doing it in the argument section of the Macro, but it won't let me alter that information.

I have a database that is set up in Access 2007, but saved down to 2002-2003 to accomodate multiple users. On my machine, which has 2007, I am able to open the database which opens to the switchboard and all the information is there, no issues. When I try to open the database on a machine that...

I am completely clueless about VBA so I am really stuck. My database was created in Access 2007, but has been saved down to allow use by 2002 - 2003 Access, and has been split to allow for multiple users. When I try to go in now at the entry file, I get the following error message: The...

Thanks. I'll check this out and hopefully it will work.

I had to make some changes to my switchboard and now the changes won't save. Somehow the connection from the Switchboard was lost in a mini meltdown the program was having and when I tried to reconnect it wouldn't work. Now I have recreated the switchboard and deleted the old one, but now Access...

They are using a shared drive.

I have a split database that allows mulitple users to enter at the same time, and that function is working fine. The problem I am having is that once they enter the information into the form, the supervisors want them to print their report and submit a paper copy (insane, I know, but they want...

I have a split database that allows mulitple users to enter at the same time, and that function is working fine. The problem I am having is that once they enter the information into the form, the supervisors want them to print their report and submit a paper copy (insane, I know, but they want...

Is there a way in Access to control the method of entry? I have been told there is a way to set it to either all upper, all lower, or proper capitalization, but I am unsure how to do this. Any ideas? Thanks!!:confused:

I am trying to apply this to my database to total items and it is not cooperating. I keep getting an error message that says I have invalid syntax and that I may have entered and operand without an operator. This is exactly what I have in the field name: Total Arrests:Sum[Felony...

I have several columns of numbers that I need to add together to get a total number for the amount of a products issued. Ex. Apples sold Oranges sold Bananas sold Total Fruit sold 5 8 2 ? The total would be 15, but how do...

I am working on a report that is based on a query and I need to know how to make it add information so that the report only shows totals. I am sure this is not as difficult as I am making it, but it seems to be the easy things that trip me up! What I have is tickets that were issued in a certain...

Thank you for your help, it showed up when I did that!! Tasha :cool:

I am currently tweaking a database that was originally created in an earlier version of Access and it has a switchboard, I need to add some new fields, but I can't find out how to get behind the switchboard to get to my tables in Access 2007. Anybody got any ideas? Thanks! Tasha