Search results

Hi, I have a table that has records added to it using the following VBa code: Const MyTable As String = "tblSampleSubmission" Const MyField As String = "SampleName" Dim db As DAO.Database Dim rs As DAO.Recordset Dim intCounter As Double Dim LastDub As Double Dim addString As String Set db =...

Hi, I am having a few issues with a query that is used to filter results in a form, the SQL follows SELECT tblMoisture.SampleName FROM tblSampleSubmission INNER JOIN tblMoisture ON tblSampleSubmission.SampleName = tblMoisture.SampleName WHERE...

Thanks Doc, The reason it is this format currently is I am using something posted on here by JoeCruse and Wayne Ryan et al to auto import a result file spat out by a spectrometer. The table looks good and the import works fine, but how do I work with the data? I could report each result...

Thanks for the help Thanks FoFa, but I don't think I explained it properly in the first place. What I currently have is a query that matches the resultID to the SampleName from another table, in the table XRFResultsConcentration there are 12 or so records with this ResultID and a CompoundName...

Thanks for the reply, but basically I am pretty stupid when it comes to SQL. Where do I put this? In the actual query criteria?

Hi Guys, I have 2 tables tblXRFResults ResultID SampleName Date SampleDate a few others not necessary in this and tblXRFResultsConcentration ResultID (many records linked to 1 record in tblXRFResults) Concentration CompoundName What I need to set up is a query that will allow me to...

Pretty Old post but having a few problems I sent this through quite a while ago, but I have adapted the code to another dB, in the line If intCounter(Int(intCounter / DubEvery) * DubEvery) = ThisDub And DoneDub = False Then It gives an error Compile Error: Expected Array, can anyone help or...

Hi Guys, This might be pretty simple, but I haven't found anything on it (might not have looked hard enough!). What I am trying to do is scan a barcode label that I created in Access, when this is scanned, it goes to a table and opens the record that contains this ID and allows me to enter...

Hi, I have split db with the backend residing on a computer in my workgroup in the shared files folder. I have access to the folder and can view the file perfectly fine on the other computers in the workgroup (a wireless 54Mbps network). The problem I am having is that almost every time i...

Thanks a lot for that, it works really well! Don't worry about my last question, I am just an idiot!

Thanks for the reply Wayne, yep, I wasn't to sure about the select case argument, I am still learning VB, from the file, what should I set it as? The file will always have the same format, with MgO being the last compond measured. I think our file varies from Joe's in that it doesn't change at...

Tried a different approach, using a different format for the txt file, here's the code Private Sub Command9_Click() Dim dbs As DAO.Database 'Pull up database Dim rst As DAO.Recordset 'Pull up individual recordset for table Dim ResultID As Long 'The AutoNumber...

I know this is a pretty old post, but I am hoping someoene can help! I am using a modified version of this ( Thanks Joe, Wayne and others!) but I was wondering if it can be simplified a bit to fit my current db.What i am hoping to do is combine the 2 tables in the code "XRF Results" and "XRF...

Hi Guys, I hope this isn't too stupid a question, but I have a db that needs to be accessed from several workstations. It is currently a split db, with the backend residing on one of the workstations in the workgroup. I was wondering if it possible (as I am looking at buying a server) to...

Thanks for the help Mailman, it works well, but i was wondering if it would be possible to have the "DUP" record anywhere in the 50 samples, not just between 45-55. That is, what I am after is to have the "DUP" anywhere from record 1-50, then another between 51-100 etc. Hope that makes sense and...

Thanks for the info doc, it was most helpful. However, the data in the table is not actual "experimental data" in the strictest sense. It is just a sample submission table, whereby we enter the samples we receive on a batch basis (hence SubNum, the submission number) and assign what tests are...

This is driving me insane, does anyone have any idea how to do this in VB?

Firstly, compact the db using database utilities (in the tools menu), then zip it with a file compression application (such as winzip, 7-up, stuffit etc) then try and post again. If it is still too big, make a copy and remove the tables that don't relate to your problem specifically then try again.

Thanks Pat, I understand what you are saying, let me put my problem another way. All the records in the table are searchable by "SubNum", which is unique for each job, not each record. What I would like to do (it doesn't have to be every 50th) is to pick a number at random from those generated...

Might be easier if you post your db so we can have a look at it.