Search results

That was it. I took the Word 9.0 library out and everything is fine. Thank you VERY much!

It is: Function is not available in expressions in query expression 'The IIf Statement'

I literally read the references from one computer and checked hers. The references are identical. Any other ideas?

I have an IIf statement in a Union Query that has been working fine forever. (Isn't this always the way?!) On ONE user's computer, this IIf statement doesn't work (causes an error). I have checked the VB references and they are all there (although I had problems with a missing reference on her...

I have Visual Basic 6.0 and I would like to learn how I could make an .exe that would do something to an .mde (say, add a record to a table, or make a new query, copy in a new form, etc.) The idea is that I would like to be able to send a disk to a client that would upgrade their application...

I have some users that tend to leave Access open when they leave work. This obviously exposes our information to anyone that happens to sit down at that computer. (User-Level Security is set up) Is there a way to have Access close itself if nothing has happened for 30 minutes or so? Will this...

If the file is really that small, and if it doesn't change often, why not just affix the info into the combo box without linking it? Otherwise, you can link to a text file as long as the delimiters are recognizable (comma, tab, etc.)

What are some of the common database applications that are used? I know Access is one, but what are others?

I'm sorry. I have tried to look this up and can't seem to find the answer to this question. It should be simple. In Visual Basic 6, where do you store the information? To use Access terminology, where are the "tables"? Thank you to anyone that can help.

There are a few ways you could do it. One would be to have the Combo Box "tell" the text box what to show after the Combo Box is updated. (You would place code in the "AfterUpdate" event) Another way to do it is to create your combo box with two columns. (You could hide the one you don't want...

To be safe, I would create a new field and update to that field. That way you are not overwriting information that you may need later. (Once finished, you would delete the old field and use the new one) For the concatenation, you want to use an update query. So you would choose the new field...

I'm not sure what you are looking to get. If you are trying to return the results of 2 or more fields with a single DLookUp, create a query with the fields concatenated into one field (i.e. "[city] & ", " & [state] & " " & [zip]) and perform the DLookUp on the query.

What about using FIRST? SELECT First(tblName.Run) As FirstOfRun, BNumber, SNumber FROM... You could use LAST as well.

There may be a more efficient way, but here is a long way around. The only issue I really see is concatenating the fields in the right order. You wouldn't want your sample to end up saying "while he ate his burger The patron fell on the floor". (Well, that one kind of works, but you get the...

Functions in VBA are a named set of procedures that can be "called" (run) from anywhere within your database. The code that I had you put in the module actually has two separate parts: Public WhoCreated As String This creates a public variable called "WhoCreated" as a string variable (a bunch...

In the Input Mask of the control on the form, put the following: ####"/"##"/"##

OK, without user-level security: 1. Create a field in your table called "CreatedBy" 2. Create a text box on your form called "txtCreatedBy" whose controlsource is the field "CreatedBy" 3. Create a macro called "Autoexec" with at least one line in it being: RunCode (Put "Autoexec()" as the...

Hold down the shift key as you open the database and it will bypass all startup options.

Insert the word "DISTINCT" in your statement: SELECT DISTINCT Left([Final_MH]![MH_ID],3) AS Expr1 FROM Final_MH;

If this is a query, it might be easier to do it from the underlying tables. Or it can be accomplished in VBA. There may be a way to do it with query but my brain is totally fried. Let us know a little more detail. (or perhaps someone whose brain is working properly might give you a better...