Recent content by tobybremner

Many Thanks---managed to get it working.:)

Thanks for the response, but Im not too sure what you mean by "set the dsn", I have tried to put the name of the dsn in the description box, which didn't work. Please could you give me an example of what I should be putting in this box? Thanks agnain

Hi I wonder if someone could help me? I have created linked tables in Access from our SQL database and I have created a pass through query using these tables. When I query the data the "Select Data Source" window appears and I have to manually select the .dsn name to return the results...

yes, spot on, thanks for that.

Sorry, I probably havent explained myself very clearly. I create the "clientmonth" field and populate these in the append query itself, that isnt a problem. Its when a user tries to add a record via the form to "tblsourcedata", after append query has been run, then this is the point I need to...

Hi, I am importing data from excel, to a table called "tblimport", then I have a append query set up so that each time data is imported it appends the data to "tblesourcedata" and creates new fields by adding, say for example, "client ref" & "inceptiondate" to give a unique identifier for that...

yes, I think that would be the best option. simplest solutions always seem to work best. Thanks for all you help.

run_categorya.. is just a private sub.

Basically I have a form with loads of comboboxes and check boxes, when certain items and checkboxes are ticked I then have a button which runs vb code called "run_categorya", which runs a query based on a table of data, filtering on the items selected. What I want to do is have an option box to...

What would I put after Docmd if i have a command called "run_categorya" if yes and "run_categoryb" is no, highlighted in red? Sorry im not the best vber If [option_toggle].value=Yes Then Docmd..... "run_categorya". else Docmd..... "run_categoryb". end if

Hi, Very new to all this. I am trying to run a procedure to say that if an option button is true (checked) then run one command if the option button is false (unchecked) then run a different command. I understand this is probably a very basic request, but we all have to start somehwere...