Search results

Thanks very much for the reply, I suppose a bit more detail would be helpful. The data in the table will be used for combustion analysis in a laboratory. We process between 500-1000 samples a day and this stage is trying to automate some of the process. The table I referred to originally is...

Hi All, I have a bit of a general query and I am hoping someone may be able to help out. I have a table and currently it has 5 fields, one of which is a nine digit number, unique for each record, which is used as a barcode identifier. The Barcode field, ID, links this to a few other tables, so...

Thanks Mailman, I can get that to work easily enough with an append query. I run into a problem when the data in the file is a negative number (our CV files can't have -ve values, hence the public function to prevent this). I tried the ABS function, but I would prefer the code to look at each...

Hi Guys, I have some VBA code (not mine as will become obvious) that takes data from a temporary table and writes it to a CSV or TXT file: Private Sub cmdMakeALSCSV_Click() Dim Accuracy As Single Dim AllowNeg As Boolean Dim Filename As String Dim i, J, TBLLoop, intRecs As Integer...

Hi, I have a form with a few command buttons and it was working very well until recently. On opening access, this form loads and all the buttons on this form do not work, giving the following error: Object or Class does not support the set of events *The expression may not result in the name...

Thanks a lot for the reply Dave. I can import it manually fairly easily, but the files are .SIF files, not .TXT files, so access does not recognise them. I guess I will have to change them all to .TXT (bit of a pain, over a thousand of them). Is there no way to extract the data directly from...

Hi Guys, I've had a bit of an issue with my DB, lost all of the records in a table (about 100000 records gone). Luckily, I have all the data in text files (.SIF files, standard interchange format). SInce they were generated by the DB, I though it would have been easy to re-import them, but I am...

Thanks for your help yet again, In answer to your queries, 1. I will look into timestamps, I haven't really used them much, I moved to mySQL a year ago as it was becoming unwieldy in access for multi-user access and mySQL seemed to work. 2. The table tblLOIData is a mySQL table and is the...

Thanks for the reply Banana, In answer to your queries: There is no time stamp in the table, but, I use an audit trail for the table (taken from Allen Browne's code) and this runs in the background, this is the code: Option Compare Database Dim bWasNewRecord As Boolean Private Sub...

Hi guys, I have a bit of an issue with our db. It has a mySQL backend served locally to our LAN with multiple users accessing. SInce I upgraded to the latest version of mySQL server, on one of the forms we use to input data, if you try and update a record, sometimes, not always, it comes up...

Thanks very much Bob, Just what I was looking for.

Hi Everyone, I have done a search for this and can't find anything (doesn't mean it isn't there) I have a make table query that grabs data from 4 tables and brings them together to generate a text file for reporting to customers. The temporary table made is then deleted once reported. My...

Thanks Wayne, I managed to solve it through the debugger and modifying the file to remove the Fe line, doesn't really need it. The code stopped when it met a line that wasn't in the select case, in the case "measurement time" I added this to the table as well as selecting every line in order...

Thanks a lot wayne, I thought it might be something to do with that. The debugger works ok, but when it gets to the Case where say SiO2 needs to be selected, the buffer still says "Measurement time 14/10/2008 10:45:18 PM" It is like it gets hung up on this line and cant go any...

Thanks for that, not really much help though. The select case, if you had bothered to have a look at the file, selects the particular data line required, i.e. the "Fe " case has the data at 17th position and is less than 9 digits long. As I metioned previously, the code worked perfectly fine...

Hi Guys, I have some Vba (Made with the help of Wayne Ryan and Joe Cruse, thanks guys) that extracts data from a text file. I had to make a few changes to the text file and I thought I did the same witht the vba, but no luck. Private Sub Form_Timer() 'set timer to x milliseconds accordingly...

Thanks Bob, Your suggestion works perfectly, very strange. I should have put the full error I was getting, I can find the table, it is hidden in the Nav Pane I get this error: Run-time error "2544" Database can't Find the MSysObjects you referenced in the Object Name argument. The system...

Thanks Bob (and Brent) Do you happen to know which references need to be set for this? It isn't working at the moment and comes up with: Can not find the object "MSysObjects" you referenced. Any ideas? I tried "UsysRibbons" as well, still no luck

Hi Everyone, I have a bit of a question, I'm not sure if it even possbile after many hours of searching. I have the following LOGIN Form code: Private Sub cmdLogin_Click() Dim strUser As String Dim strPWD As String Dim intUSL As Integer 'Check to see if data is entered into the UserName...

Thanks Bob, That seemed to be the issue. Curious how it occurred in Access2007 only after converting the backend to mySQL. Have added to your reputation.