Search results

Hey guys, I would like to be able to link a table from another database and then run some queries and stuff on it from a macro. I know that I will need to use the TransferDatabase action (with the Link type). The only issue is that I would like to be able to specify the to the database to link...

I have a macro that I would like to open a Query in design view (so that the user may edit the query), and then run the query after the user has edited it (like when the user closes the design window). However, when I use the OpenQuery command to open the Query in design view, the macro just...

Okay, total newbie to Access here. I've set up my database rather, now I'm trying to design rather specific reports. The report will only include data filtered by a form/query. I'd like to be able to do something like DCount("x",<THIS REPORT>,"x=1") but I don't know how to reference only the...

I have a set of evaluation response data. There are a number of question (like 20), and each respondent answered the question on a scale of 1 to 5. Thus I have a table Responses where each column is a question and each row is a Respondent's answers. Each cell has a value between 1 and 5...