Search results

You can not use a comma to append you must use & as in err.number & err.description or err.number & " " & err.description. Try msgbox "Error Number " & err.number & "Description " & err.description. This is handy when debugging and it can be changed to a more useful display to the user by...

In your database options set your options not to display the full menu and objects. In 2007 you do not display the navigation pane and do not display the menus (ribbons). Set your startup form as required. Then convert to mde or accde. In 2003 from memory I think it is Tools then Options.

Right click on the table then select table properties then tick Hidden in the Attributes

Use the Change Event of the text box to test the ASCII code of the character entered if it is between 65 to 95 then it is a letter. Now, is a ' e.g Tom's or a space permitted in your text box?

If the record source for your combo box a query, set the criteria for the field EmployeeTemporaryInactive in the query to false then your requery should work.

PLease list what you want on the form and the function of the form. The form can not be created unless you know the requirements.

Reply to me off list and I will give you some assistance.

Here is a sample database that may help you. You will need to modify the code to suit your field names etc.

I glad that the updated version provided a solution to your problem. I used new queries so that I did not interfer with your existing queries that are used elsewhere in your database.

Here is an updated version. I have modified my previous version with the following changes. 1. Created a table tbl_temp_inventory - this will hold a snapshot of the current inventory. 2. New queries qry_append_temp_inventory to append the inventory snapshot to the table tbl_temp_inventory...

So when the StructureT form opens and the Structure Number is added to Work Pack a snapshot of the material available for the part numbers of the Structure number is displayed in BomF. Now your requirement is to update the Status field of the part number of the structure number with Available...

Use the Search option in the banner. Enter Calculate Age in the criteria to display various posts regarding age calculations.

Desperate What is the purpose of the form StructureT? I have assumed that if an part is available, then the InventoryT will need to be updated with a entry to show that required quantity for the part has been used by the form StructureT.

Here is an updated version of your database 1. The Run Alloc allocation code has been changed. This code will need to be modified so that the required fields in your InventoryT table is updated with the required data when a new record is added to this table. Inventory.AddNew Inventory("Part_no")...

Post the relevant table, query and code etc. and I will have a look at your question.

You may need to cycle through your WP and then your Stock. Do Until WP.EOF STOCK.MoveFirst Do Until STOCK.EOF If STOCK!Part_No = WP!Part_No etc, etc, etc, For each record in WP you will need to move back to the first record in your Stock so that the new totals will be used.

In the Got Focus event of your combo box use the following line. DoCmd.Requery "name of combo box"

Your welcome, I normally upload databases created in 2007 but saved in 2003 to the site. Yes, you are correct ' determine the limitation date If client_age_incident < 18 Then child_limitation = 18 + Me!statute_limitations Me!limitation_date = DateAdd("yyyy", child_limitation, Me!client_dob)...

sonof27 From my understanding of SOL it is the maximum time from the date of the incident that a client can initiate court action. Using your example above as person over 18 must initiate court action within 4 years of the incident. For a person under 18 that person must initiate court action...

Glad to assist. The attached example uses arrays. When you open the database a form is displayed to enter the number for each denominations in the till ( your database could populate these fields). Enter the sale price and the amount tendered. Click on the Display Breakdown and the change...