Search results for query: *

I do this in my database for importing a BOM. I'm always appending and the source xls file is always different. In my case, there is a lot of variation so I import into a temporary table first and allow the user to review and check the data before commiting it to the live table using SQL...

In fact, you could even create an ERO lookup table with two columns, Increment and ERO. Populate the ERO column with every possible ERO number that you could ever use. The Increment column is simply an integer 1-500 or however many thier are. Now, when you enter a new ticket, look back at...

Don't delete the record. Trust us, you'll apreciate this some day. Add a primary key, even an autonumber if you have to, and keep all these records. Let the HDX00 field repeat, but have a unique ID field in addition. From the sounds of things, with manual interaction with someone elses...

I was thinking of doing something similar, and found the following link explaining that you CANNOT link to another access back end using a password. http://stackoverflow.com/questions/862803/specify-mdw-file-in-embedded-connection-string-to-another-jet-mdb-possible

Make the control source a function, you can pass data from a field in the current record easily. txtSomeTextBox.ControlSource = "fGetSomeData(SKU)" Then make a function to retrieve the data you want from some other program, modify it if needed, and return it as the result of the function...

Ok, looks like I'm screwed. Other queries with left() dmax() mid() etc continue work fine. Only NEW queries with functions/expressions fail. There seems to be corruption afoot. A /decompile and compact/repair has no effect. I have no idea what references I need or HOW to check for them...

The target machine(s) do not have ms-access. They only have the ms-access runtime.

I was suspecting references, but was unsure what specifically the problem would be (what specific reference I needed). Anyway, the LIKE variation works great (for one option)! The other option uses len(fld)=5 and I don't think there is a way to use LIKE for that. Being a text field using...

Hmm, its fairly straightforward but requires a lot of code. Are you familiar with VB? I'll throw some ideas out here, but don't have the time to code a complete solution. You'll have to handle the transition from strings to numbers a little better, and figure out if you're incrementing just...

I am trying to find the highest value in a table and increment it, putting the new value in a text box on a form. Everything I'm doing works fine on my workstation with full access-2000 installed. It fails on workstations with the access runtime "The expression After Update ... function is...

I realize I've posted this in the wrong place, I'm reposting in the VBA forum.

I am trying to find the highest value in a table and increment it, putting the new value in a text box on a form. Everything I'm doing works fine on my workstation with full access-2000 installed. It fails on workstations with the access runtime "The expression After Update ... function is...

Don't you have to link an access database to an explicit \\server\drive\folder when using it as a back end?" Yes, but the web server application (asp) that is running and trying to access the access file is the default IUSR_XXX account with no network privledges. If the file is local, it works...

Thanks for the tips. I have been playing with ASP trying to connect to the ms-access back end and I'm finding that its very easy if the file is local to the web server, but quite problematic on a network share. AD user authentication is a breeze with IIS. I'm editing in notepad now, but I...

I have created a ms-access 2000 program, but I am wanting to move parts of it (and eventually maybe the whole thing) to a web based application. For some reports, basic queries, or simple data entry, this will be much faster than the large and slow front end I have now. I would also like the...

Worked like a charm, thanks.

I have a front end MDE file and back end MDB on a network share. I am using the access 2000 runtime to make this available to ~40 users. This has been working fine so far. I just ran into two computers that won't open the file after installing the runtime, I get a null result when clicking on...

Could you re-create the entire file each time its written? Maybe by using a extra boolean field in your table "IncludeInFile". That would probably be easier than searching it out and deleting lines, but I don't know the whole picture. Is there anything in the file that would relate the line...

In the simplest terms, 1) put the file in a shared folder that everyone can access 2) use it

You have to modify the code to suit your database, I have absolutely no idea what forms, controls, or fields you have nor what you want to write in the file. Furthermore, you'll have to hit the debug button when you get an error and see where the problem is. It should highlight a line in...