Is it possible to close and open forms in vba from another form that is being used, my input form is named Collection and the form I want to close is called...

I have created a query that lists what our guests had for lunches. Some have simple two course meals - others have buffets with up to 10 items. At the...

not a computer wizard, Can anyone tell me what these are? I got it in a returned email notification failure from who i sent an email to. I don't know if they...

Hello! For a Veterinarian database, I can't seem to get the form/subform structure working. Open the form. Enter the date. Then, in a subform below, enter...

I am relatively new to access. I am using access 2007 to create a report that contains subtotals. When the report is displayed on the screen the subtotals...

Hi Is it possible to make a label visible during the OpenReport command? I have the following commands: If option 1 is selected -- DoCmd.OpenReport...

Public Function my_dates(the_date As Date) As Integer Select Case the_date Case Between "07/31/2005" And "08/01/2006" my_dates = 2006 case Between...

One of our Access 2007 databases seems to have encountered some difficulties with crashing. There are 18 users, and approximately 75000 unique records. This...

I have created a database with a form that comes up as an initial menu. Unfortunately, the form isn't maximized inside Access, but is windowed. I have...

I have been trying to create a crosstab query which will display a daily total, monthly total and the yearly totals of our ordered sales. I have a daily total...

Hi my favorite is windows vista it's easy to use an it's feel like free to use Rgds Dinuka

I have a button on a form called "command9". When this is clicked I want to go through all the entries of a table called, "Device Table". I using the following...

At work we are going to be setting up a MS Access database for some geological data. We are going to be getting some other data in .csv format that we would...

Hello all, I posted this question previously, but would appreciate any further assistance anyone could give. In Access2K I want to open a report in preview...

I have a field which I want to have an initial capital - I know this can be done by an input mask but I was wondering how it would be done with VBA? Some code...

I have a table where there are numbers stored for the values. How do I get those numbers to print out the corresponding words in a report. Example 1=yes...

Hi there I am currently trying to split my database for my users (since there are 10 of them) but I am getting an error message. It says the...

Hi, I'm not sure if this is the correct forum to be asking this question, but I hope still to be able to get some help. I work for a photography place at a...

While entering records into database, I entered the same record two times. I deleted the record with the duplicate information and then added a new record....

My problem is this: I have been programming in xBase dialects and clipper for 15 years and keep putting off getting up to speed on OO stuff. Anyway, my other,...