Search results for query: *

Hi All- I have an after update event as such: Private Sub BirthDate_AfterUpdate() Me!Age = Year(Date) - Year(Me!BirthDate) End Sub Here is the weird thing, the [Age] field will update correctly after you click "End" on the runtime error. Runtime error 2448 You can't assign a value to this...

I have an AutoKey macro that will work out on the network but will not work on the server. I simply copied it into the front end of the workstations and all is well. When I am working on the server though and hit the f12 key I still get the windows save as dialog box. {F12} Open Form...

Can anyone help to steer me in the right direction on this? I have assigned a default PayType to each employee. Here is the PayType Table. PayTypeID PayType RegRate OTRate 1 CLRK $10.83 $17.52 2 SOD $8.32 $18.26 3 HKA2 $7.75 $14.40 4 T&P $12.51 $21.54 5...

I was wondering if it was possible to create a report that would indicate missing number like your checking statement does. I have of course, an inventory listing and was looking for an easy way that I could find out what numbers were available. The Product Names start with 1000 and go through...

Does anyone know why suddenly the system requires me to relink each individual table instead of all of them at one time like I use to? RookieDev

I split my databases on the server and put a copy of the front end in a folder of each user's system. Now when I try to access the databases on the user's PC's the database starts to open and then a message comes up that it can't find the BE. If I get lucky the database will minimize and I can...

Good Morning all! I am using access 97 and I am having some serious performance problems using an unbound combo box to find a customer. I was hoping someone could offer some advice as to how I could speed up the process. It is so terribly slow on some computers on the network that they can go...

I was hoping maybe someone could help me with a date time problem I am having....I have 2 unbound text boxes that are populated by this code: Private Sub Form_Open(Cancel As Integer) Me![Beginning Date] = Date - WeekDay(Date, 4) + 1 Me![Ending Date] = Me![Beginning Date] + 6 End Sub...

Does anyone know how the tabs on a tab form can be changed. There is not a property to change the back color and I was hoping one of the brilliant developers out there had come up with something. I use tab forms alot and love the effect but they seem to be very limited. Thanks! Rookie Dev

Can anyone help me with this? I think I need a series of queries to change a value in the Transactions table based on record totals from another table but I'm not sure how to go about it. Here is the Transactions Information collected when the Products are purchased: TransID TransDate ProductID...

I AM USING THE INVENTORY CONTROL PROGRAM IN MICROSOFT 97. WHAT I AM ATTEMPTING TO DO IS ALLOW USERS TO SIGN OUT PRODUCTS USING A FORM AND THE VALUE DEDUCT FROM THE QUANTITY. HERE IS THE SET UP. THE FORM USED TO SIGN THE PRODUCTS OUT USES A COMBO BOX TO ALLOW THE USER TO SELECT THE PRODUCT AND...

I have a combo box that looks up an address and then displays the Customer information for the selected value. There are currently 1840 addresses and the process is getting slower all the time. Does anyone have any suggestions? This is the row source of the combo: SELECT DISTINCTROW...

I need to do some archiving of records that have a great deal of associated data. For example: Each Customer has Workorder records and each Workorder has Labor, Parts and Billing records. My concern is that I do not know how to get all the associated data archived properly for the Workorder...

Ok does anyone have their "Smarty Pants" on today? I have a really tough one this time.. I have a Main Form Employees-it has many tabs,,one of the Tabs tracks our Labor for timesheets.So..I have a Sub Form called Time. It displays as a datasheet because we need to see what hours have...

I have had great success with the Select Case information provided by the experts here, however I have run into a snag when I try to change a combo box that uses a value list. I typed it in as such: Select Case Me.PaymentMethodID Case Is = "22" Me.TAG ="VAC&quot...

Is it possible to set up a report that will print a number 10 envelope? I have a report that prints out and I always need to mail it. Right now I have to go through all kinds of changes to connect to Word. I would like to keep it all contained in Access with the same underlying query as the...

I have a form that automatically enters the current date. I also have a field that is a list box that the user inputs a value: E=Emergency-complete in 24 hrs U=Urgent-complete in 5 days R=Routine-complete in 15 days I need to automatically populate a field called:ReguiredDate based...

This thread is in response to the Labels 2 thread where CosmoKramer-gave some excellent advise on getting labels to print based on the value of a quantity field. I took his advice and the solution worked on my home computer but when I installed it at work my reports gave me a message =Trim. Any...

I HAVE AN INVOICE REPORT THAT WILL NOT DISPLAY THE VALUES ENTERED AS CURRENCY EVEN THOUGH THE FORMAT IS CURRENCY. WHEN THE REPORT IS RUN THE USER IS PROMPTED TO ENTER THE VALUE OF "ITEM ONE","THEN THE COST", "THEN THE SUBTOTAL" ALL OF THE FIELDS ARE TEXT BOXES. I...

I have a Sub form on a Tab Form does not go to new record when focus is moved to a new employee. I have an employee time subform that I enter daily time into. When I click the next record button to move to a new employee I can't figure out how to give focus to the time subform and automatically...