Search results

No Worries at all. you and David were both very helpful to me. I"m just starting out with database design and i have taken over some systems that dont appear to have been set up correctly (relationship wise) originally, so it makes it that much harder for me.

Hi Mihail Please see above for the workaround I used. I'd say that the work around is probably not the best way to do it, but it will accomplish what I needed. Thank you very much for your help.

Thanks David...yeah when you mentioned temp. copying it over, it gave me an ideal...i'll just convert that ODBC table to a local table here in my Database,and every time the ODBC data changes, i'll have it run an update query to update this local table....this will accomplish what i'm trying to...

i just figured out a work around....not ideal, but it'll def. get the job done. I appreciate all of your assistance on this! Thanks a lot!

I can copy the tables into my database just fine....problem is that the schedule data (in ODBC Table) is always changing, and so i'd have to run an update query to update that copied table everytime the schedule data was changed in the ODBC table. I was trying to avoid that, so that is why i...

yeah nothing still appears. It could be b/c one of the tables that im using to get the route number and scheduled time are linked tables to an ODBC database that isnt actually stored in my current database? Thank you for your help by the way!

i can, but it's empty. When i click on relationships, nothing shows.

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...

got it!! Thanks again for everything! You are a lifesaver! This helps me out more than you know!!!

or actaully i dont have it tied into the command button but i'd like to. i have a command button on my form called (command198) and i'd like to be able to tie that code to that command button...meaning when I hit that command button, it mails the report to those particular contacts in qry_contacts.

Thanks... one more thing. I have it tied to a command button called (command198). is there any way to tie that into the code above?

Thanks so much for your help... i'm getting an error report, but I think I can track it down from here! I really appreciate it!

Thank you so much! I really appreciate it! Query name is (qry_contacts), feild name is (email)

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...

Sean, that worked great! Thank you so much! I worked on that all day yesterday! BoyDay, that would have probably worked too now that I think about it. Thanks for both of your help!

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...

Thanks. I actually went into the SQL and got it to work finally, but it appears, looking at the design view, that the way you reccomended would have worked as well.