Search results

Hi, thanks for the reply, I'm getting this: syntax error in query question '["*" & [ID] & "*"]' Any thoughts? A.

I haven't been able to google this because I'm not sure how I'd word it!! I have a form, which registers attendance at an event, with three fields - ID (a combo box), Name, and Present. When an attendee comes in, they give their number which is entered into the first field. Pressing carriage...

Greetings, I am using a barcode font in order to generate a number as a barcode on my report records. In order for my barcode scanner to read the barcode it needs an asterisk at the beginning and at the end. So, if my record ID is 62 - in order for the barcode to be displayed correctly, it...

You are absolutely correct - I didn't realise access differed between 'report view' and 'print preview' - I feel like such an idiot! Apologies for squandering all your time! Andrew

Think this should work: The form in question is 'badge' https://www.dropbox.com/s/qbxzlb73271k0t5/sfCOPY.accdb.zip Thanks

Hi just wondered if anyone had thought any more on my dilemma? Do you want me to upload the DB?

I have it in "details" and "format" if that makes sense. Andrew

Hi, Thanks for your help - I got it working perfectly on the form - but for some reason it won't work on the report? Any suggestions? Thanks Andrew

That's fantastic, thank you so much!

Thanks for quick reply, You've lost me - where have I typed something wrong? Sorry - I'm not very apt at reading code! Andrew

Hi guys, I'm trying to get a form to print just one record on a report - and using this code: Private Sub Command24_Click() Dim strReportName As String Dim strCriteria As String strReportName = "Badge" strCriteria = "[ID]='" & Me![ID] & "'" DoCmd.OpenReport strReportName...

Hello, I need a little help doing something on access which to me seems very complicated! I am making a very simple 'registration' database for a children's event in a couple of weeks. I the table/form there is a checkbox field called 'consent' which, if checked, indicates that a child can...

Dale, Ah yes I see what you mean now. Perhaps I have been slightly misunderstood - there is nowhere in my database where the date will be entered manually. The reason is that I will be needing to register 100s of people within a very short time, so we're trying to keep input per person to a...

Thanks again, I understand that better now - one thing remains unclear. SelectMe.Text5 should be replaced with your Date selection control name. What does this mean? Thanks

Hi dale, Thanks for your swift responce. As I'm not familiar with code, where in the VBA editor should this go, and in relation to which form element? Does any of it need changed to suit my database (sun, mon, etc). Andrew

Hello, I'm making a very simple flat file database for an event I'll be involved with in a few weeks. It's a registration form (Name, Contact number, Age) but it also has check boxes to record the attendance of each member (Saturday, Sunday, Monday, Tuesday). Each day a person attends - the...