Search results

SubforControlName.Requery is exactly what I needed thanks a lot

Good morning All, I have create a form from scratch in which I included a combo box linked to a table (customers table) next, I created a query that outputs all the order made by a specific Client based on the selection of the above combo box. so far all works perfectly well. Next I dragged...

indeed attached is the reference table / table field

Hello All, Below is a Macro I wrote assigning a picture to an image box on a form. it worked properly then stopped for no reason. it is now generating runtime-error 2220 ============================================ Private Sub Combo45_Change() 'This is the By Part Reference ComboBox Dim...

Some people work in a company, some are on their own.

Good Morning, Just Created a Form with a Combo Box. The combo box lists all the companies in the table. nonetheless, not all record contain a company name. is there a way to get rid of the empty spaces? Thanks in advance Roland

Good afternoon, I am trying to use the Nz expression as part of my Expression Builder Formula, however when I click OK the following message appears: The Expression Nz([Old Stock]) + Nz([New Stock]) cannot be used in a calculated column. Can anyone help? Thanks.

Good morning, I am currently working on a stock management database, where all my stock is stored in a table "Table_Stock" This table was created and included the original stock quantities when I first created my database. Today we are placing an order for new stock. Should the existing...

any reference to the "front and back en concept" ? (any tutorial article etc...) Thanks

currently the DB is on my PC and I am the only one accessing it. Nevertheless, we have a server in the office, and I assume the DB eventually needs to be located there?

it is a spare parts database. users will enter the part number and extract necessary info. The form is ready and operating well. Thanks Roland

Good morning, Can anyone refer me t a good tutorial on how to make my database accessible (read only) on other pcs? Thanks in advance Roland

Oops Indeed, Thanks a lot Roland

Good morning, While viewing the query in design view, I am unable to see the relationship tables at the top. Can someone help? Thanks Roland

Thank you for the reply. This is exactly what was needed. Roland

Greetings. I have created a simple stock management database using 3 basic tables: 1- Stock Table 2- Client Table 3- Transaction Table. I also established the 1 to many relationships: Stock to Transaction & Clients to Transaction I also created a query that allows me to list all the items that...