Search results

So I have a subform that shows directly on my main form. Dependin on which route i select in a seperate combo box, that specific route information shows up in this sub form (route#/Scheduled Time). I want to add some extra columns to this subform so that, for example, if a route is running...

Hi I have designed a DB in access 2010 and it opens fine on my computer. However, when others I work with (who still have 2003) try to open the database, they get the following error: "An Error Has Occured Trying to Load The Form "Form Name" - Do You Wish to Continue". When I click Yes, it...

I have the following code tied to a command button in access. I know the code is right b/c it'll generate the email and attach a file in my lotus notes, however, the attachment is not in a pdf format. Even when i take the acformatPDF out of the code below and I chose PDF from the prompt, it...

I have a report that has only 2 columns (Routes and Carriers) The report extends downward and takes up 3 pages. I want all of the data on one page and when the data string extends to the bottom of the page, i want it to start over again at the top of the page (right where it left off at the...

Hi I"m a novice at anything access, so I apologize in advance for my ignorance. I am trying to get access to email a report to email addresses in a query (qry_contacts). Filed Names within the query is called "email". I am able to get access to generate the email, but the only way I can get...

I need to delete info in tblshipmentdata_working that matches 2 fields (Plant and Code) in LITOSD. for example, I have in LITOSD a row with Plant = 203 and Code = PD1. When I run the delete query, it's pulling Plant = 201 and Code = PD1 from tblshipmentdata_working to delete. It looks like...

I'm trying to delete all the rows in one table when the supplier code is equal to the supplier code in another table? Can this easily be done?

I have two tables (Base Table and Changes Table) with identical fields and field names. All records in the "changes table" need to be moved over to the base table, and the same records within that base table that already exist need to be removed/replaced. I have a field called "supplier...

I posted the other day and received helpful feedback, however I still cant get the query to do what I need it to do. I have a table with the following columns (Pick Up Route, Intermediate Route, Intermediate Route 2, Delivery Route) The PU Route and Delivery Route will ALWAYS have a route...

I have a table with the following info: Supplier.......Receiver.......... Cost............... PURotue........... IntRoute.......... Del Route ABC Inc....... Dubab ...........$44.00.............. P-355 ..............I-335 ..............D-15 I would like to know how to make a query that will add...