Search results

When I am in the VBA window, sometimes there are no references or I get a list of items but nothing marked "MISSING". I think it has to do with my ActiveX Calendar Control. I had code on Activate ActiveX10 = Date so that it would open to the current date. This worked fine until I also put...

I'm not sure where to start. I've been writing some code a little bit at a time in my database. Last week I wrote code to maximize all my forms on open and on activate. Then this morning 3 of my forms were giving me error messages that "Module not found" ON these 3 forms I also had code...

My shading does print from Excel. I am able to print the shading in Access now, but only if I go directly to print without going to print preview first. It seems kind of strange.

I have some reports that have shading on them. You can see the shading when you view the report, but the shading doesn't print.

Is this possible? I have 2 reports: 1 with all jobs except the ones on the second report. But I want the daily/weekly totals from the second report to feed into the first one's total.

I have a report where I have changed most of the original page setup settings but the changes won't stay. I read about some glich in Access 2000 that requires changes to be saved in page preview. I save it often in page preview but every once in a while it still reverts back to the original...

I have a form with 2 subforms. I have my subforms totalling on the main form. Now, each time a job is pulled up, I need to make sure the amount on the main form, CONAMT, is equal to the total of the subform. If it isn't equal I need some kind of message to come up on the screen. I'm not sure...

I thought about linking the fields, however, I don't want the 2 field amounts to always be equal to each other. The amount in the field of the parent table will change while the amount in the field of the child table will remain the same. When the record is added in the child table, that will...

I have a form and a subform. I want a date from the subform to be updated with a date from the main form if a condition of another field on the main form is met. If New Job = "Y" Then Ship to Amt will update to JOBCONAMT Where and how can I write this?

Thanks! It's working now.

I have set up some simple vba coding on open of my report. It looks like this: LSCNO.BackColor = IIf (IsNull(COMPLETION_DATE), 1677215, 12632256) CUSTOMER.BackColor = IIf (IsNull(COMPLETION_DATE), 1677215, 1232256) I want the 2 fields LSCNO and CUSTOMER to have a white background if the field...

Thanks for all the great advice. The "System" Table is exactly what I did. Then in my query for the report, I joined the 2 tables, added a field that prints either "Prelimb" or "Final" depending on whether our Shipping manager has entered "yes" for a particular date. It works perfectly!

I'm sure it is, but I can't figure out how to make it work. I have a Shipping report from information entered by our Shipping Department. I need to have the Shipping department enter a date or something somewhere that will let everyone know that the report is ready to print. Then when the...

It works! I did the code a little different. Thank you for the push!

I am trying so hard to force users out of the database after a certain time by making a docmd.quit on the opening of my startup form with a timer. I've tried to be creative but nothing works. Does anyone have any ideas? I have setup a table with a sysquit time and sysavailable time and I'm...

I am trying to prevent users from entering my db after 3:00 pm. I have read some examples but I can't seem to make it work. I have a table with 2 fields: shutdown(yes/no) and time. I also have a form that opens when my db opens and it is based on this table. Now I'm trying to write my code...

I am trying to prevent users from entering my db after 3:00 pm. I have read some examples but I can't seem to make it work. I have a table with 2 fields: shutdown(yes/no) and time. I also have a form that opens when my db opens and it is based on this table. Now I'm trying to write my code...

I was wondering if anyone can suggest a good way to learn VBA. I already use it a little with Access but my company wants me to go to a class to really learn it. They want me to do something pretty intense for about a whole week. I have about 2 years of Access experience and that's the only...

I have some forms that I cannot delete and when I try to look in design view I get a message that my form is mispelled or refers to a form that doesn't exist. Also, I have a bunch of temporary files in my queries that can't be deleted either. Also, when I go into Security Permissions, my...

how can I make the Calendar Coltrol always default to the current date. I tried changing value on the property but can only put a particular date in there.