Search results

Thanks again Rob, Close but no cigar though; The problem I had with the Access Error message - "Access cant find the Form etc." was due to the fact that the fieldname had a space - this was being used in vba as Record_Id whereas SQL required it to be [Record Id] I've tried using a variable &...

Yep, I changed the Formname to the correct form name. It just doesnt like it very much ;-)

Hi Rob - thanks for replying, I've tried the new SQL string, I couldnt get WHERE (((tlb_CurrentTasks.[Record ID]) = [Forms]![FormName]![Record_ID]));" to work I kept getting Error msg "Access Cant find the form [formName]" so I tried using: WHERE (((tlb_CurrentTasks.[Record ID]) = " &...

Hi all, In my database, I have a field called "Comment". I'm displaying Continuous forms so I don't have a lot of space on screen. With this in mind & as the Comments field is optional I decided I would include it as a Popup - Double click a field & the following code runs: 'Build the SQL...

Hi Rick - just tested on my machine & all was fine - are you still having problems?

Hi Rick, If you put the text boxes in a group footer, they should count the records for the group. If the text boxes are placed in the Report footer they should display the totals. Is this what you're doing? I'll verify on my own machine & post back any updates. Regards, Patrick

In your Report, in the Report footer or a group footer, add two text boxes. Set the control source for each text box to =Count([YourFieldName]). This should do the job for you. Regards, Patrick.

More work? Are you trying to depress me?? :-) Thanks again!

Thats Great AutoEng - thanks for the advice. Just one more for the folks at the back though - if I'm not going to be making any more changes should I just leave it the way it is?? Thanks again - Patrick

If the macro is converted to VBA it will display the code it uses. I.e. If a macro is created to open a form then the code it uses is docmd.openform anyway. A macro is just a way of doing this if you don't know how to write the code. If you create a macro then goto Menu - Tools->Macro->Convert...

Hi all, I'm currently working on a multi user database which will be used be approx 50 people. This is the second phase & the initial phase is up & running until I replace it with the latest version. The thing is.. At the moment, everybody connects to the database via a shortcut to the opening...

You need to specify "Len" in the query criteria. i.e. Len([YourFieldName])<"8" Regards, Patrick

Hi Wayne, this is great stuff & I'll start looking into this now. Just on the other point about the logic being applied to the form - the form is a subform displaying continuous forms. This is why I feel the need to loop thru the records in the background as when I try to validate at the front...

Don't know if this is of any help to you but... To check if text is bold in a text box you use the fontbold property i.e. if text1.fontbold = true then the text is bold. HTH Patrick

Hi, Currently I have a Db which stores Time sheets. The user fills out their weekly timesheet then submits. (A Filter is applied per-user so that only their own records are visible to them). A query then runs in the background & flags all of the submitted records to "Submitted" & makes them...

If the RecordSource for the Combo box is a query then you can change the sort option in the query itself to "Not Sorted"

Add a Label to your switchboard - E.g. "Help" Then change the HyperLink Address property for the label to the location of the doc. that you wish to open. Regards, Patrick.

try using .text = "" instead of .value = "" Hope this helps!

Why not use a calendar control to allow the user select the start date, then add on the amount of days required using code in the background?

Perfect!! Thanks Rob!