Search results

Well the loop is asking for a different piece of information each time depending on what is selected on the list. The problem is only happening when it runs the report with the newly created SQL string which is being created properly i think.

I've got the following code to ask the user what criteria they want to use for generating an SQL string which is then used to generate a custom report. Now it does work and registers what the user types in, however, all it does when it opens the report is bring up another input box with what I...

Hey thanks for the response but think i've sussed it. Basically I've got a multi select list box which shows fields that can be chosen to be displayed in a report, and what I was wanting to do was have it automatically show and hide the controls of the report according to the selections made...

Hiya. I was wondering if anyone could help with the code needed the edit the caption of the labels and the source of the text boxes on a report, when they are being taken from a multi select list box. Thanks

Alright cool thanks. I'll take another look at it over the next couple of days and get back to you on here. Thanks for the help :)

Oh yea I completely forgot about them not being able to create it. Alright i'll use a template type thing, but would they be able to edit the controls like that in runtime even through VB??

Well i'm making a report in which the user specifies the fields each time from a form, so there is no guarantee which fields are going to be chosen, and WAY too many combinations to create a report for each, so I'm trying to make it create it each time. I can use a template though so I can...

ahh fantastic, works perfectly, just what I wanted, thanks very much :D

I'm able to create my report (although it only opens in design view) and i've found the CreateReportControl method to add fields and things I need, but I do I use them both? Dim rpt As Report Set rpt = CreateReport DoCmd.Restore That Is the code I'm using to create the report, and I already...

How do I set a limit to the number of selections in a list box? I've used the following to check how many are selected, but how do I then tell it not to allow new additions, but it can remove current ones. Obviously I can't lock it or disable it as I then wouldn't be able to de-select them, so...

Yea just figured that one out now, thanks. Works a treat :)

Hey, thanks. it seems to work but I don't see the Query in the Queries list or doesn't this create it there? If not then that's fine, but How do I get it to actually run the query as it isn't doing that? Thanks

I've generated the SQL string needed for the query, but how do I go about actually creating the new query? I've found various things on the net, namely the CreateQueryDef (I think) but couldn't get it to work. does anyone have the exact code or resource I need? Thanks

Theoretically you should just need to split the database into a front end back end setup so many users can access it at once. If you create a copy of the database, then in the front end, delete all the tables and only keep queries and forms and reports and such, and in the back end copy, delete...

Brilliant got it all working now. Thanks for you help, was brilliant :)

ok, i've put DoCmd.RunSQL "UPDATE tblAccessLog" & _ "SET TimeLoggedOut = Time, DateLoggedOut = Date" & _ "WHERE LogID = LogsID;" But it's giving me a syntax error. Probably the variables that i'm using are wrong or is it something else?

No. I don't really have that much experience with SQL in honesty. How do I add 2 fields to be updated rather than just the 1?

Update it. I was just a bit lazy, and just copied and modified the script that created it

DoCmd.RunSQL "INSERT INTO tblAccessLog " _ & "(DateLoggedOut, TimeLoggedOut) VALUES " _ & "(#" & Date & "#,#" & Time & "#) WHERE " _ & "(LogID = '" & LogsID & "');" Could anyone possibly tell me why this isn't working? Probably something stupid i've done...

ah brilliant, thanks. I'll go take a look see what I can do. Thanks for your help :)