Search results

Hi all, I need to add some data to a table using a form that has slightly different fields that need to be entered depending on who the data is for. It is used to enter data based on a particle size analysis and we have a lot of different screen sizes, not all of these are used for each...

Hi All, I have a module in my Access Database that looks for a text file in a folder, renames it (due to the weird extension the original file has .QAN) as a .TXT file, grabs the data and deletes the file. This is called on a timer, and usually works well. However, if the module falls over, the...

Hi All, I am not sure if this is possible, but here goes. I am making a split form which allows a user to "filter" records shown in a part of the form based on the criteria the user selects. What I want the user to be able to do is select about ten of the records (could be more or less) shown...

Hi All, Is there anyway that I can get access to "remember" values in a private sub routine after the sub routine has closed and use that value again once the sub routine is run the next time? My value might be say 14 after the sub routine is run the first time, so I would want to start at 15...

Hi Everyone, I was just wondering if there is a way to have an if statement that can determine if the number it is referencing is a multiple of another number? Like: If "my integer" = " a multiple of 10" THEN etc... can I write it as If "my integer" = 10 or 20 or 30 or 40 etc THEN... This...

Hi All, I have been struggling with this for a while, and it might not be the best way to go about it. I have a form which is unbound, on the form I have 126 text boxes grouped in to sets of 3 each. The text boxes are named and are grouped as such: ID_1, CW_1 and IW_1 ID_2, CW_2 and IW_2 etc...

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...

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...

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...

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...

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...

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...

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...

Hi All, I have jst swapped to a mySQl backend (long story) and it seemed to be working fine, however the following code is giving me an error: Private Sub cmdMakeJHCSV_Click() Dim Accuracy As Single Dim AllowNeg As Boolean Dim FileName As String Dim i, J, TBLLoop, intRecs As...

Hi All, I have recently been converiting my former access backend to mySQl, all seems to be going well, but, after about 3 days of pulling my hair out, I can't figure out why the following script is not working! Line Input #1, buffer While Not EOF(1) Select Case Mid(buffer, 1, 2)...

Hi Again guys, I have a database application, front end on the local machines, back end on a server (it happens to be a mac server, but still works). Recently we upgraded to Access2007 on all systems, but left the backend in 2000 format. Ever since then we have been having issues with our users...

Hi All, Many thanks to all who have helped in the past. I have a form which is linked to a table, pretty standard. The form header has a combo box for the user to select their user name when they are entering data. Each record has 5 fields and when the final field is updated I would like to...

Hi all, I am tryng to make a form with a sub-fom in the header, all pretty easty so far. The subform is a login form with a username and password control and a command button "LOGIN" with the follwoing code: Private Sub cmdLogin_Click() 'Check to see if data is entered into the UserName combo...

Hi All, I am attempting to use the Audit Trail code form Allen Browne's excellent website and I am having a few issues. In my forms Before Update Event I have the following Private Sub Form_BeforeUpdate(Cancel As Integer) bWasNewRecord = Me.NewRecord Call AuditEditBegin("tblLOIData"...