Search results

Dim db As DAO.Database, sSQL As String Set db = CurrentDb() sSQL = "UPDATE [Dive Crew]" _ & " Set [Dive Crew].InitInvConf = -1" _ & " WHERE [Dive Crew].InvoiceNumber = '" & [Forms]![frmInvoice]![cboInv] & "'" db.Execute sSQL, dbSeeChanges ' Single...

Your question is way too vague. Do you want to concatenate two fields and store them as one field in the second table? Or do you want to select a record in one table by doing a join to fields in a second table? Or something else?

While a lot depends on the situation, you might start by checking for interactions in the Form_BeforeUpdate event. Something like: if DrugInteractionCheckFails() then MsgBox "You got a problem." end if

Not sure what you mean by "using a module". Problem happens with code in modules and code behind forms. I use code behind a form to export the object design to text files. The front end started out as Access 97, was converted to 2002 at some point, and is now 2010. The actual problem seems...

Access 2010 keeps changing the Capitalization of objects when I don't want it to. For example "Cancel" becomes "cancel". Later it will be changed back to "Cancel". There is also a table with a field "FULLNAME". Several Queries build a field "FullName". As a result FullName, even in places...

I'd suggest you start figuring out how to make the changes you need one at a time. Open the Visual Basic Editor, then search for "Welcome back". You'll find the code that pops up the message. Study it a bit and it see if you can figure out where you would have to copy it, and what changes...

Sounds like you don't understand what the different properties do. The Control Source determines the field where the choice is stored. The Row Source determines where the choices come from. Your storing the users selection in the same for both combos. Won't work. Play with it. You'll...

The English wording is not clear, but your data is in the wrong fields. I think you need something like this:

You need to set the 'Control Source' to different fields in the underlying table. The 'Row Source' will be the same for both combos.

Are you looking for someone to make the changes for you? (Pro-bono?) Hire help? Or give you some guidance on how to do it?

I looked at your data, and a few quick observations. First, assuming that "StudySummary is the raw data you receive, I'd write a vba routine to process the raw data into a normalized database. Then the problem become trivial. (Studies, StudySpecialties Where Studies has fields: StudyId...

In your situation, I would definitely use two columns. Hopsital names do change, and more frequently than you would expect. (St. Johns to Mercy in multiple cities. Local hospitals bought out by larger ones, etc.) Sometimes I use a single column, but only when the "Key" will never change...

Private Declare Function GetUserName Lib "advapi32.dll" Alias "GetUserNameA" (ByVal IpBuffer As String, nSize As Long) As Long Function WindowsUserName() As String Dim LngBufLen As Long Dim strUser As String strUser = String$(15, " ") LngBufLen = 15...

Right now you have data that may be "Not available", "Not Entered", what happens if you discover you need "Validated", "Missing", "Suspect", or other flags? Without knowing a lot of details it's hard to come up with a design, but my experience has been that two fields are much better in the...

There is not enough details in your post, but it sounds like you are breaking normalization rules that will make your new Access data a headache. Split your old data into two or more new fields, where each field holds only one type of data. Strings of dates should become mulitple records in a...

Instead of moving the files, save a link to the files. I prefer to use a parameter that points to the head of the folder structure, and save only the subfolder\image01.jpg (or .bmp, etc.) in the field. Below is a process that I use to read a folder and add a record for every new file in the...

I had tried db.tabledefs.refresh. That did not work. This seems to have fixed the problem. ' force a reload to avoid a quirky error. db.Close Set db = OpenDatabase(vPathname)

Sometimes this line of code works, sometimes it gives me error 3011. DoCmd.TransferDatabase acLink, "Microsoft Access", vPathname, acTable, vTableName, vTableName When I step through the code in the debugger the values have always been valid, and when I step through it it always works. But...

This link gives the best overview of the pros and cons of Access that I've seen. http://www.fmsinc.com/MicrosoftAccess/Strategy/index.asp Access is quick and inexpensive for smaller projects, shouldn't be used for larger ones. My experience has been that problems increase significantly as the...

If it's adding " AND " in the joins sounds like your trying to link the same table three times. Instead add the individual_tbl three times (Access will name it individual_tbl1, individual_tbl2, etc.. You can rename them to a1, a2, a3) Then set up the joins you need for each of the three tables.