Recent content by drstein

What you recommended does not work ofr me yet. What I did was to drag some tables to the design surface and I wanted to show the relationship between the 4 tables. Yesterday I had a design option from the menu bar and now that design option does not display. That is how I was able to drag the...

In a graphical display, I would like know how to show the relationship between 4 new tables in an access 2007 database. I know that I setup this relationship since in the past but I can not get the 'arrows' to show up in the graph. i looked at the following link for assistance, but this does not...

Thank you very much for your answer! It definitely worked! I definitely want to imporve my use of sql using Access. I am working at a company where I work on various databases like oracle, sql server, access, sybase, db2, and nonstop sql. In all these database languages, I have been trying...

Can you tell me what is wrong with this query using access 2007? can I have two inner joins? SELECT mp.MRH_Id, mp.MRP_Plan_Id, mp.MRH_Create_Date, mp.MRH_Submitter, mp.MRH_Batch_Id, mp.MRH_Request_Status, mp.TRC_Code_Id, mp.MRH_Tran_Count, mp.MRH_Batch_Size, mp.MRH_Batch_Percent...

I would like to know what the sql is in access 2007 to update 5 columns in one table that is joined to a second table.

On the controls on top of the form, I am selecting export and then I select 'word'. When I select 'word', the only export option is 'rtf'. I would rather have the export occur in a regular word document format.

I have created some reports in Access 2007 that I exported to word in a RTF format. The data exported, but some of the following parts of the report did not show up on the rtf file. The items that did not export are: 1. The title of the report, 2. text boxes that surround different data...

I just obtained an access 2007 database to work with that has 3 forms in it. From what I have seen on the internet, I thought the forms are setup for data entry. However when I click on the forms, it looks like a search is being performed. Can you tell me how to determine when forms are used...

I modfied a query that includes a check for tr_code not = a certain value. The following is the query: SELECT [A3].P_NAME, [A3].P_ID, [A3].LAST_NAME, [A3].FIRST_NAME, [A3].PHONE, [A3].PHONE_EXT, [A3].[TR Code], [A3].SumOfCount, [A3].[Batch ID], [A3].Submitter, [A3].[Create Date], [A3].[TRC...

Can you show me a reference on how to delete rows from a selected data in access 2007? I am used to writing my own sql in sql server 2008 r2 and I am not used to using a designer. I basically want to delete rows that a query shows where rows have been duplicated.

I am trying to import some data from an excel 2007 worksheet into an access 2007 using the import feature of access 2007. I am tyring to use the column headers in the excel workhseet. However I am getting the following message: The first row contains some data that can't be used for valid Access...

I want to be able to do a search in the sql of reports and queries to look for the following words separately: 'delete', 'insert', 'update'. I have not had success in this area so. I do know that there are 'insert' statements becuase I can find them when I open up the queries. Thus can...

Can you tell me what you mean by 'some other event'? What are the other events and how do you access the other events?

If the access 2007 database I am working with has templates, can you tell me how to find and use the templates?

I am asking the questions about: 1. stored procedure, 2. function, 3. view, 4 script to run that completes several tasks. Since I have alot of access 2007 databases that I need to work with and have no expereince with access 2007. I do have expereince with sql server 2008 re2.