Search results

Ok, I've figured out a good method using a module ModSearch whichmakes it really easy.

Hi All, I'm trying to figure out the following: I have a query and on my form a drop down box. I'd like the query to show all records if the CboBox is blank but narrow the query of a value is selected. I've tried various including below but just cant seem to figure it. Like "*" Or...

In my Db in various forms i use code such as me.txtbox=Time() and it works fine except on one form where it doesnt give a value. Are there any circumstances that would make this a predictable outcome?:mad:

right! Cancel that help request as I've found the answer. It was due to my main form (from where my update form is opended from) having record locks on. Doh!

I'm having a strange problem start up where for some unknown reason I have a form which is based on a query and the form is to update customer details but when i try and type in the field access just beeps at me. Similarly and obviously if I open the query I cant update a value directly in the...

Step 1) Recreate the linked table but based on a File DSN. for a multi-user approach and/or multi machine a file DSN is definately a step forward.

Many thanks for the info. I will investigate and post back.

Would i be better setting the DSN as a funtion in VBa?

Just thought I'd feed this back for info and to ensure I'm not keeping issues to myself! I've noticed that the ODBC linked tables seem to have to have the link setup on the actual machine. And then also per user logon too. Each installed instance of the front end (although I havent split just...

I Luv'ya Bob!! Top Banana :D That fixed it.

now I've found that the ODBC links setup on my developer machine did not carry though. Also, ODBC in 64-Bit Server 2008 doesnt give the choice of a system DSN.

Ok, I've managed to trap the error and on the server for some reason the OBBD connection fails also though the system dsn tests absolutely fine. hmm..

I'm thinking that there may lie the key? Maybe the 32 bit references dont work on the 64bit opsys? any thoughts?

Hi Bob, having just followed your greatfully received advice I copied your altered string and then debug compiled and then packaged. Installed onto the 64-bit machine and same thing happend. Works fine on my developper machine in access runtime which is 32-bit. The access runtime 2007 on...

I've noticed that, having installed the runtime version on my developing computer, that I dont get the runtime crashes. The system which its being deployed on is Server 2008 64-Bit.

I've debugged my Db to the point where I know that at the following line of code Access Runtime Halts on a runtime error. I'd be gald of any advise? :confused::confused: My Db works perfectly on my PC and full version of Access strRadAcctID = DMax("[RadAcctID]", "RadAcct", "[UserName] =...

Basically i am trying to get around an issue where when the query is opened using access runtime version the application halts. If I run the query in VBa instead would that get around the issue?

I'm trying to convert the following query and use DAO, can anyone ploint me in the right way in constructing the same but using DAO, or suggest the/another best way? INSERT INTO TblRadAcctLocal ( RadAcctId, MacAddress, FramedIPAddress ) SELECT Max(radacct.RadAcctId) AS MaxOfRadAcctId...

i found the answer! the names were the wrong way round but its not a full solution as its not doing the same as my QBE query - On the right track though... I i think this is the aql of my QBE query.. INSERT INTO TblRadAcctLocal ( RadAcctId, MacAddress, FramedIPAddress ) SELECT...

Right, I'm testing the following code but getting a runtime error 3625 item not found in this collection. Debugging highlights rs2!UserName = rs1!MACAddress Dim db As DAO.Database Dim rs1 As DAO.Recordset Dim rs2 As DAO.Recordset Set db = CurrentDb Set rs1 =...