Search results

Could you use two criterias, for example On your date field Between ([Forms]![myForm]![srqStartDate] & [Forms]![myForm]![srqEndData]) and the criteria for the time field Between ([Forms]![myForm]![srqStartTime] & [Forms]![myForm]![srqEndTime])

All sorted. Had I just properly run the append query it works fine. Checking the actual data before doing so was producing these weird symbols.However it all appended fine to the actual table.

Hi guys, I've been having a lot of problems with a particular query which is returning strange symbols like ڗ. I've found a lot of information on this occuring with memo fields, yet I am not using any. I'll give a quick overview. I have a form frmStaff, which has a staffid, projid, startDate...

Hi, I'm still quite new to vba and access and still learning my way around everything so take it easy if I'm missing something simple :o I have a form, StaffAdmin and on this form I have a 4 fields and an OLE object, which has two copies. The first copy is a locked object which is there as the...

could you store the value in another variable rather than a field, and access it using that new variable

managed to get it working using staffid = 0, was making the mistake due to it actually being linked to an id field but displaying names. I still used Nz() = "" for theother fields so that ended up helping, so thanks.

Editted code for indenting, it just copied horribly, didnt notice sorry. Ive tried If Nz(qualid, "") ="" then and it came up with the same issues im having. The main issues are with the qualid/staffid as in the code i did manage to get Nz(trainingrecord, "n/a") = "n/a" working fine

hi i am trying to figure out some issues to do with null values of combo boxes for my db. Ive run through multiple different pages and used varying solutions to check for a null value of my combo boxes (ie nothing selected), all failing miserably for me so im thinking there may be an issue with...

just using Adobe Reader X

Hey guys, I've currently got a problem printing PDFs which are linked via a hyperlink field. Im using access 2010 and ive got a field in one ofmy tables called certificates which is a link to a specific certificate for each person. I cannot figure out how to open all of these PDFs and print it...