Recent content by DigitalS27

CJ, I did not provide something you want to see. I changed somethings this morning to try and get it working. I added a new combobox which I name cboCustomerSel as the other combobox was still on the form and could not give it the same name. Also with the row source I tried using a manual...

Uploaded database

Thank you!! Will upload now. There is no confidential information as this is a very small app that prototype for our lab to just enter sample information when samples are received. Currently they do it in excel :)

SELECT [dfs_Customers].[Customer_Number], [dfs_Customers].[Customer_Name] FROM dfs_Customers;

AFter I added the customer_number to the report, now when clicking the button to view the report I get the following error: Data type mismatch in criteria expression

I have added a field customer_number to my report. but i still get the same error. can you please explain how i can edit this to remove the customer_number from my code?

Sorry I meant customer number and not CustomerID. I have tried what you suggested, but still get enter parameter value error.

Hi guys, I have created a small database for entering samples received and condition of the sample. I then created a simple report and added a button on a form with a start date and end date field. So on the form the user selects the customer from a combobox, the user can then enter a start...

Good day guys, I am trying to split my access database. I copied the access file to my local drive then I click split database. the computer loads for a while and then instead of split successful I get a prompt record deleted. Can you please assist ?

Good day everyone, Our company currently uses an MS Access database for data capturing - the front end is on each users pc and the backend is hosted on a company server. However, with the increase in popularity of the mac, and Access not available on Apple what can we do in this situation ? I...

Customer can have many equipment. 1:* Lots of equipment can belong to only one customer. Maintenance can be carried out on equipment more than once a year. Just woke up so can't think clearly what the relationship syntax are :banghead::D:o

Hi guys, So, I have created a database with 3 tables: tblEquipment, tblCustomer, tblEquipementMaint So what we do is we enter the customer name, customer is related to tblEquipment, and equipment is related to equipmentmaint. First the customer is entered on the database form, then the...

Hi guys, We have a small lab database where we insert the results of a water plant test. The results can be either Before treatment or After treatment. And it can be treated numerous times a year. I have created form with a drop-down box to select the customer and a button to show reports...