Search results

BamaColtsFan: I'm not that familiar with SQL. Doesn't your SQL INSERT statement give you a single spreadsheet with only the last record inserted? I'm still looking for a solution so, while I loop through my recordset, I can do my calculations and write to individual columns in a given row. I...

Thanks. That's an ultra simple way to do it and will not meet my needs. As I loop through the recordset I need to make many calculations, constructing fields using various pieces of data.

I am currently writing tab-separated text files, which are then imported manually into an Excel tab. I would like to use Access 2003 to write directly to an Excel .XLS file with one tab. I've seen some examples on this site but there's a lot of extra code in those samples and I don't know what...

Nevermind. Format returns a string, not a number. Code should be: dim l as long dim s as string l=10000 s=format(l,"000000")

I have a number, say 10000, but I want it to be 6 digits with leading zeroes. This did not produce an error, but it did not work either. Searching these forums and Access help did not help me. dim l as long l=10000 l=format(l,"000000") l is still 10000 not 010000. Thank you.

Thank you! That worked. I'm so used to Perl where "call" is optional.

I am getting an error in some code behind a form in a button click event. Here is the code: Do While Not (Myset.EOF = True) signtype = "C" signsize = "11x7" ' Construct ItemID from PLU. plu = "" If (Len(Myset!Myplu) = 4) Then plu = "PLU"...

- 2000mb (2gb) is not that big for a database. - Native Access can handle about 1 million records but it does slow down a bit. - Why is your MDB file so big if there is only 2500 users? Are you storing any images with each record? Try opening the MDB file, going to Tools, Database...

Logic would say that, if the user's do not know enough to find the version of access they are using, and which update file to download, then they should not be updating their own software. They need an IT guy to do that onsite. But I also realize some businesses simply won't hire an IT person...

Please note, when dealing with filenames, any string with an asterisk on both sides of it, does not work properly in any version of MS-DOS. In fact, this syntax does not work on any version of DOS or unix I have ever used. In theory it is possible, in practice it is not.

If your input file (a text file) is simply a list of DOS commands to be executed, simply have your text file have a file extension of ".bat", and now it's a batch file for DOS. Each command is on its separate line and will be executed in order it is entered in the batch file.

Why not have 2 text boxes on your Access form? One for email subject, one for email text.

Yes, I tried using my Windows network username and password. But the CreateWorkspace function might be looking at an Access username and password, that's my guess anyway. Please keep in mind I don't want to update ALL objects in an MDB file, like some other tools do. I just want to pick the...

I agree. The variable "sum" is defined in your procudure, but the variable "val" is not. That might be another problem.

DJKarl, Isn't an XSLX file the new Microsoft XML file storage method for Office 2007? That would mean it is indeed a text file in XML format.

Yes, I close the entire Access Application, not just the MDB file, and often the Immediate window does not clear. It cleared yesterday though, when I closed Access. I will often come to work the next day (after closing all my apps but leaving the PC on) and start up my MDB I was working on, and...

Access 2003 on Win XP I have a test MDB file where I do all my work. When my changes are done, I want to copy the changed objects (forms, queries, reports, modules, etc) to the "work" MDB file. My current code from Access95/97 is not working. It seems to want an Access username and password...

Thank you for your help.

Access 2003 on WiN XP Ok, I've been searching this site and Google for an answer and have not found one yet. I have a single column list box with a Value List (items separated by semi-colons). How do I sort them in ascending order? I swear Access used to have this in A95/97, now it doesn't...

I need a list of forms, queries, and reports. I used to have code which showed these which worked in Access 95/97, but something changed and my code no longer works. I believe I need to look at all the MSYS* tables, I think what I want is listed in there. How do I do this? Thanks.