Search results

copy object Use the following code DoCmd.CopyObject "destinationdatabase", "objectnewname", sourceobjecttype, "sourceobjectname" example DoCmd.CopyObject "C:\mydatabase.mdb", "copyofreport1", acReport, "report1"

You may want to try something like Application.DoCmd.SendObject If you look at the help files in access it will tell you how to specify output formats etc. To get it to happen when you select a text box you would need to put the code under the Gotfocus event of the text box.

You could use a macro to force it to a new record or code as below DoCmd.GoToRecord objecttype, "objectname", record, offset Changing the various bits fo the code to the names of your forms etc.

create 3 queries query 1 to bring back results of anything <Date()-183 query 2 to bring back results of anything >Date()-183 query 3, create unmatched query based on the above two comparing and looking for customers that do not exist in query 2.

Go to the table design view, hold control down and select both fields you want, right click and select primary key. I think.

what fields do you have in your query

Could you not get the people who send you the data to use a spreadsheet template that you have created. You could then use validation to regulate what they can enter.

do you have this in 97 format?

it says it contains ambigious outer joins. ???

struggling with this, hope someone can help. I have a table of timesheets that contains records for staff but it only contains weekly record if they have actually created that weeks record. I also have a table of weeks that contains all of the available weeks that time can be booked against...

If I remember correctly when you open Access and then open the database through file / open you get options listed in the bottom right corner of the file browser box. Or Tools / Options and the advanced tab, Default open mode.

Still not got any further with this.

A little extreme but have you restarted the server. One of our servers keeps locking files, saying they are open when they are not. Another thing may be the datebase is being opened exclusive, when you select file open, check the options, you somethimes have problems with a 97 database and...

SELECT DISTINCTROW quetion.qpk, quetion.question, quetion.answer FROM host INNER JOIN (quetion INNER JOIN [junction table] ON quetion.qpk = [junction table].qpk) ON host.hpk = [junction table].hpk; This is the one that does not work until I remove the junction table

I tried creatating a query but it doesnt work when the junction table is shown on the grid, mismatch in join. When I remove the junction table the query runs and looks like what I kind of expected, however if you update a record it cascades through all of them.

I think i have done what you said but it has not quite worked. I changed the child & master fields to link to the respective PKs. What happens now is that I get only one record listed in the sub form which is different for each main form record, when I was expecting 5 records for each.

I am aware of these but never had to make one, what I have done at the moment is create two tables and a third junction table. I have created the one to many relationships to the junction table. I have created a form and a subform to view the data. What happens is I get a list of products in...

makes sense now you put it like that. Cheers

Thanks, this works. If anybody out there wants to add a reason why it thinks the cell has no data it would be appreciated. Perhaps sometimes we just have to except things are the way they are. Thanks everyone for chipping in your ideas, much appreciated.

attahed example