Search results for query: *

How come PA comes up like "Pa" but NJ comes up correctly with NJ after i type the abbreviation in the exit the field. Anyone?

i came up with a solution. it uses 2 queries then a Union select on the third. The problem was i had to change the caption because it combined data from 2 fields. Hope this helps someone in the future

Thanks for responding. please note there is only 1 ORDER BY clause and Access help says there should only be one and the end of the second select. any more help or experience?

Does any one now how to do a union select with a where clause coming from 2 fields. For example: Select Field 1... From AAA; Union Select Field 2... From AAA Now the Where clause is giving me a problem. This is it in plane terms. I want the record to show up if it has "xxx" in...

I read thru some treads but still can'tome up the answer. i am trying to come up with a calualation of time. i at least am trying to get the difference like the number 5 in this example. For Example: Text Box1: 3:50 PM (Medium Time Format) Text Box1: 3:55 PM(Medium Time Format) Total Hours...

First is in th OK button of the Loggin Second is the hidden form that pops up and checks links. Maybe becaus eits hidden? -Doug ----------------------------------------------------- Private Sub BOK_Click() On Error Resume Next Dim y Dim x Dim vNewPassword Dim vUserID As Long Dim vPassword On...

my StartUp shows the Database Window is not supposed to come up (is not checked). It doesn't pop up, instead it brings up the Startup form i have selected. So, till this point all is ok. The form it brings up is basically a custom Dialog pop up that allows the user to loggin. After the user...

with the following code I usually can use a dlast method to get the AutoID number assigned. I'm having a problem any ideas on how to retreive that number? ------------------------------- Set dbs = CurrentDb Set rcrdset = dbs.OpenRecordset("Candidates") rcrdset.AddNew...

I am not getting any errors at all i simply type a few letters, or click a couple of times at Access quits right out. No error, no messages no nothing. It doesn't quit properly for there is still a .idb file. No Access on this machine does the same thing with all databases. I tried...

On one computer (even 2) the Access DB works fine On this one Access kicks me out after a couple of key stokes, never encountered this before? -Doug

I can't type anything in the &quot;Find&quot; field of the help window. The cursor appears as <--> and locks me out I was using VBA in Outlook before I do need help with help -Doug

I can't type anything in the &quot;Find&quot; field of the help window. The cursor appears as <--> and locks me out I was using VBA in Outlook before I do need help with help -Doug

I program with VBA in Access. Now I want to build a bridge on the other side with Outlook. After I make a userform in Outlook how do I display that form to the user? -Doug

I develop Access databases but i need to know its limits or when it will start to slow down if I have a back end and front end. Is conversion to SQL when it splits like this time consuming. I know it depends on how complicated the DB is dy I guess I am looking for some experienced guidance on...

How do I use the EditMode property on a form I was going to put it on the beforeInsert event what I want to do is replace the edit bar with my own. -Doug

...to set it to a string variable. It seems the lookin is &quot;stuck&quot; on some setting of &quot;c:/winnt/...&quot;. Any ideas? thanx -Doug ************ With Application.FileSearch .NewSearch .lookin = Forms![Organizations].Form.CompletedQuestionnairesPath .SearchSubFolders =...

...to set it to a string variable. It seems the lookin is &quot;stuck&quot; on some setting of &quot;c:/winnt/...&quot;. Any ideas? thanx -Doug ************ With Application.FileSearch .NewSearch .lookin = Forms![Organizations].Form.CompletedQuestionnairesPath .SearchSubFolders =...

Is the &quot;In&quot; statement in place of the &quot;OpenDatabase&quot; statement? My problem starts with the &quot;OpenDatabase&quot; statement I get a pop up to choose the db type. It's the OpenDatabase line that is the problem first. If I just put the &quot;In&quot; statement I still...

...choose the db type. I think I can use the &quot;connection&quot; argument for this but I can't figure it out. It's the OpenDatabase line . . . ***************** Private Sub BSecurityOnOff_Click() On Error Resume Next Dim strSQL As String Dim ws As Workspace, db As Database, rs As...

Thanks that should do it . . . -Doug