Search results for query: *

I'm having trouble with a result set that returns null values that I want to convert to a zero numeric value. If memory serves me right, the following function would return a zero if applied to a null value field. Nz([field1],0) When I use this in a query, the field returns a 0. But for some...

Does anyone know how to prevent Access from selecting all the text in a text box when you tab to it in a form? I want a user to be able to tab (or press enter) to get the focus on a text box, but have the cursor at the end of the existing text in the control rather than highlighting the entire...

What would be the best way to create a message box using VBA that will pop up when a procedure begins running that tells the user to wait . . . Then closes when the procedure completes. So the user doesn't think the app is hanging.[hourglass] I tried using the msgbox function, but it seems to...

I'm trying to create a function that will export a linked table from the current db into another one. The only problem is that it's exporting a link to the back end to the other db. I want it to actually export a copy of the back end table to the new db, but I need the process to be done from...

I have a problem with a few of my workstations that occasionally attempt to read an empty floppy drive. This occurs only on some of our computers when Outlook 97 is open. It occurs sporadically, almost as if Outlook is trying perform something involving the floppy drive on a timed schedule...

How can I create a recordset from the following tables: Table1 Field1 Field2 Field3 Joe 12 Manhattan Tom 22 New York Ed 20 Chicago Table2 Field1 Field2 Field3 Karen 15 Anaheim Susan 17 Los Angeles Jan...

Does anybody know if its possible to have the detail of each record on a report repeat itself based on a set number? For example, I have a table with customer information. I want to print customer info and I want a copy for each customer. However, each record includes more than one customer...

Can anyone tell me what I am doing wrong? I have linked a table from an ODBC database to my Access database. I want to assign a value from a field in the first record of the table to a variable using a module. When I run the code it returns the message "Record is deleted." Here's...

I am using an SQL statement to create a table, but I want the table to have a field with incremental numbers like an autonumber field. Also, I want the query to use a starting number based on user input. Can this be done and how? Any help would be greatly appreciated.

Crosstab queries are great.&nbsp;&nbsp;But can you base a report on a crosstab query where the field names created by the crosstab are not static?<br><br>Here's my situation.&nbsp;&nbsp;I have a crosstab query that groups data from a three month period into three columns like...

Is there any way to create a query that automatically sets the criteria for a date field to only include date within the current month?