Search results

Yes this is definitely achievable but what I'm not quite sure about is if you are going to need something more sophisticated than just a scanner i.e. will you need a bespoke program to go on the scanner. In MS Access you can create your barcodes - which can be any alphanumeric combination e.g...

If I understand this correct you want to send an email to all records in the subform. If so you need to loop through the subform's recordset. So, in your code you would do something like this: With Me!SubformName.Form.RecordsetClone' Set MyMail = doc.MailEnvelope.Item Do Until MailList.EOF...

Hi, Can you clarify what you have at the moment scanner wise.

Just wondering (only because I never use them) why you are using a DAO recordset? Also you could try and add what type or recordset you wanrt i.e. Set rstEc = dbs.OpenRecordset("tblEvCancel",dbOpenDynaset)

Try something like this: If not isnull(MyRS![E-mail Address]) then TheAddress = MyRS![E-mail Address] With objOutlookMsg ' Add the To recipients to the e-mail message. Set objOutlookRecip = .Recipients.Add(TheAddress) objOutlookRecip.Type = olTo End if

What versions of Access are all your tables/database in? Have you tried compact/repairing everything?

Are you writing in to the form and then copying the new data across. If so I did something similar recently but here's how i did it. In vba create Public variables for each field you want to copy. On the AfterInsert of the form copy the data from each field in to the variables. Now when you...

In your doses table add a field that is going to link to the main form's id (so make sure they are compatible). Now in the data type for the new field choose the lookup wizard and go through the steps linking it to the main table. Now open your relationships window and enforce the relationship...

Hi, There's smoe good discussion here http://www.tek-tips.com/viewthread.cfm?qid=1134076&page=1 about this subject - the bit near the bottom about wizhook might be what you're looking for. Good luck

You just need to add the code within code to to the onclose event like this: Private Sub closeFrmswitchlogin_Click() On Error GoTo Err_closeFrmswitchlogin_Click Dim db As Database Dim prop As DAO.Property Set db = CurrentDb Set prp = db.CreateProperty("allowbypasskey", dbBoolean, False)...

Are these codes actually stored anywhere? If so, if you use a combo on your report you should be able to set this up to work. If not you can format it in the query behind the report. Do something like this: Create new column in the query and put this in the name: FormatCodes: iif([CODEFIELD] =...

What security screen are you trying to bypass and why?

When you say switchboard is this a main form that has buttons to open other forms? And are these forms opening but with no data? Do you have a front and back? If so, are they linked properly?

Try something like this (replace FIELDNAME with your field name): If Me!FIELDNAME > 0 then Me!FIELDNAME.Enabled = False Else Me!FIELDNAME .Enabled = True End if And like DCrake said you will need this on the AfterUpdate of the Value field and OnCurrent of the form Regards

You should be able to do this using DLookup do a search and see how you get on.

Put something like this on the OnCurrent of your form and AfterUpdate of the textbox: If Me!cbox Like "H*" Then Me!cbox.BackColor = 16744448 Else Me!cbox.BackColor = 16777215 End If Note: Change cbox to your textbox name and change the number values to what ever colour value you require

This should be achieved by adding a Group By to the fields in the query. Click the Totals button on the toolbar or go to View/Totals

What does status refer to? Is is it a form control? If so, put me!status

Sorry, after re-reading your post I see you did say 'serial number or anything else' but my solution would be just for serial numbers. I don't have a solution for searching everything at the same time.

Try this: ProjectList(0, 0) = Me!Application0