Search results

In my Autoexec macro, I maximize the current window, then open my main menu form. Where else could code be running during startup? Also, the stuff that stays in the Immediate window is stuff I had entered, like printing a variable. This is not stuff output by Access, Access code, or an Access...

Access 2003 on Win XP. My Immediate window is full of stuff I did in the past and it does not clear when I close the MDB file or when I close Access. How do I clear the Immediate window? Thanks.

Access 2003 on Win XP. I have a form. This form has 2 list boxes: lstSearch holds all possible records in a table called "MM". lstDest holds records the user chose out of lstSearch, and is linked to a table "tmpMM". I have 3 combo boxes used to limit the records in lstSearch. The user...

No. Does the Duplicate Record wizard search on a given field? Here are the possible contents of my PLU field: 1111 2222, 1111 1234, 4557, 8899 For my purposes, the first and second records should pop up as containing the same PLU of "1111". Also, can the Duplicate Record wizard be set up to...

Thank you.

I have 2 recordsets in VBA code, each is based on a different table, but the tables have the exact same layout. One is the main table where data is stored, the other is a temp table used for selecting records then processing them later. Each table has 50+ fields. How do I use a single command...

Access 2003 on Win XP. Is there a built-in object in A2003 which will allow me to search a recordset, to look for records that have the same numeric (4 digit) number in a field called "PLU"? The field in my recordset "PLU" is actually a string which contains 1 or more 4 digit numbers...

In your query, in a date type field, in the criteria area, dates have this format: Get dates between Jan 1, 2009 and Mar 4, 2009 inclusive: >=#1/1/2009# and <=#3/4/2009# This is assuming your OS date format is for America. Dates are formatted, and handled, differently in Europe where their...

In Access, right after you read each text line, before you process the line, replace all tabs with null: s=replace(myline, chr(9), "") Check in Access Help to see if this replaces only the first instance or all instances.

I don't think Access can do this natively. You will need a 3rd party object, then learn how to reference it (Tools, References), and use it.

My initial thought was to use a listbox control. All I want to do is show all (or filtered) records from a single table, on a form. Is another control a better choice? The listbox does not let the user change the width of the columns. Also, the user may want to sort on a column or two in the...

No, it is not possible. A Word document, and Access report, are completely different on the inside, though they may look the same on the outside.

Why change the 2nd number to a barcode only when printing? Why not always have it be a barcode, since the actual value of the barcode is always present anyway? So, the number is already appearing twice, once as a number, once as a barcode. There's no logical reason to change the 2nd number to...

I have A2003 on Win XP. Whenever I search for help, it searches online help first. How can I set Access to search only offline help by default? Thanks.

In the Excel cell you will have to change the font to the correct barcode font. But that means the cell height must also change, manually or automagically, to correctly show a scannable barcode. The other thing is, different barcode schemes have different prefix characters. If I want to...

I have A2003 installed on my Win XP machine, but all other Office apps are Office 2000 (Excel 2000, Word 2000). I would like to take a table/query in A2003, and write it to a .xls file with a single tab. Each field in Access would be a column in Excel, and each record in Access would be a row...

Thank you. I have not had time to look at it yet but I will soon.

Mr. B, No it is not a split application. I am storing the actual MDB file on a network drive. Your advice is sound for a large user base, but not for this particular application. We will only have 2 users for this database and it is not worth the extra time to do what you mentioned. I am more...

A2003 on Winxp In my application I want to check the username. If the username is not mine I want to disallow access to Tables, Queries, Forms, Modules, Macros. How do I do that in VBA? Is this called the "Database Window" under Tools, Startup options?

Thanks. Guess I'll just have to make my own form in Access then.