Search results

Just some quick notes 1.) A company is a company - whether it's a finance company or a supplier.... so they belong in 1 table - you either need 2 tick boxes or better yet a junction table for company types. TblCompanyType CompanyTypeID CompanyTypeTblCompanyTypeJunction CompanyTypeID...

Create a query and make the 8 and 9 digit barcodes in that by concatenating the fields as required. There is no need to store the barcode

You're welcome. Just post back if you run into difficulties

Microsoft access has a limitation in the length of a report section to 22 inches.

Do you need to use internet explorer? Have you considered using the MSXML straight from VBA?

I'm not sure I see the problem then... Is the web site working? Have you tried creating a database and linking the tables from the website database to that database? Can I asl why have you bothered for a web site? Why not just do it all in access?

You've not posted the code you are using to call the macro. Why use a macro at all.. you could use some code like Insert this code behind the button you use to open the report. (cmdButton refers to the name of your button) Private Sub cmdButton_Click() On Error GoTo ErrorHandler...

I would suggest you do it like this. Create a table that you import your CSV File into, once you've processed the CSV file you clear the table out for the next day Create a query based on the CSV File table.. something like SELECT DISTINCT CustomerName, Address1, Address2 FROM TblCSVImport...

So in this example I will call your work that you are carrying forward a "Job" You could have a table with the following TblJobActions JobActionID (PK - Autonumber) JobID (FK to Jobs Table) JobDate JobAction (Created/Completed) Then create a query for All jobs that have been created before...

I assume the web site is based on a database? WHat database type is it? If it is access and the site is to remain local then it can be done (but I think you will suffer with the database being locked when people try and access the website). If the web site is to go remotly then really you need...

why doesn't the user update the 2nd field directly?

This is the first thing I would do when designing ANY access database and I believe it will enable you to troubleshoot your current issues if it doesn't fix them

you're welcome. Just post back if you are still struggling.

Why? Why are you storing this information in 2 seperate places?

Do you have multiple users accessing the database through the same MDB file?

The update should come from the Front end... all the backend should do is sit there and hold the data. Why doesn't it let you update it? what have you tried? do you get any errors?

Ok... so create a query with all the results in... create a report based on that query, create a form with controls on to filter the query and then add the criteria like I mentioned in my previous post to filter the query.

What do you mean by Update the tables? Do you mean change the structure? Yes you can but what do you want to do... Can I also ask why... Will these be regular changes? Usually regular changes to a database strucuture points to structural problems.

Macro's are really not the best idea... they limit what you can do. I have a print report macro that steps through each Test, determines if the Test was completed as part of the overall assessment and then either prints the test report or skips the test report (True = Print, False = Skip) How...

This is called Query By Form. Create a query and add in your table... add in your fields and in the criteria of the one you want to search by add in forms!YourSearchForm!TextBoxName so your SQL for the query would look something like SELECT * FROM YourTableName WHERE...