Search results

I'm not 100% sure on this, but if you are using a list box, set the number of columns to 2, and include your item in the first one and the price in the second. If this list box is on a form and populates your table from there, it should work. But, you really need to work out whether you need...

Hi, I'm not sure if this is the best way to do it, but it works for me. Firstly, you need to write a macro and call it whatever you like. The macro action should be 'goto record' and the 'Record' (at the bottom left) should be first, last or new, depending on which record you want to show. In...

Open your form in design view, select the very top left square and right click, select properties. The 'Data Entry' property is in the 'Data' tab and should be set to no.

Hi Kentwood, It might be better for you to post your db here and let everyone have a look at it (removing anything confidential, of course) instead of trying to send it to some one. Probably best to compact it first, using utilities, and zip it before posting.

Hi Guys, I hope someone can help with this. I have a table, "Blasthole Submission" which is populated by input in a form, using the code below: Const MyTable As String = "Blasthole Submission" Const MyField As String = "Sample Name" Dim db As DAO.Database Dim rs As DAO.Recordset Dim...

Hi Joe, Thanks for the info, it was very informative. We also use SuperQ (pretty much the only software) and import our data in a different way. I know that the latest versions (on the 14xx series machines) allows you to auto export results files and call a dos based application to do the data...

Thanks Gizmo, works like a charm. I just ordered Access vba for Dummies, I think I need it!

Thanks for that, I will have a look and see what I can find

I hope someone can point me in the right direction. I have a reasonable grasp of the basics of access and would like to learn more. I have set up a laboratory information management system and it works ok, but I am looking at learning how to make it easier for the end user to work with and also...

That works perfectly, thanks a lot. I have another little problem I hope you can help with. The table I am updating has another field in it that needs to be the same for all the new records added. Is there any easy way to do this? Previously, I put it in a form in an unbound text box and put a...

Thanks Gizmo, i didn't even think of that, makes life much easier!

Hi Guys, I posted on this forum a few months ago chasing a solution and still haven't found something. Is ther any way in vb that you can prompt the user to input a number? I was posted the code below to try and help. In the example below, i would like to be able to have the end user input the...

Thanks Sonny, much appreciated. It might take me a while to work through it, but atleast it gives me something to start on. Will post how it turns out!

Thanks for the reply Phil. The problem with the error message is that the table that it is appending from has 3000+ records in it so it says can not add 2998 records due to primary key violation etc. The primary key is a generated number and should be unique for each record, i.e when the record...

Thanks SJ, I'm not very good at VBA. How would i go about making it so that there was a pop up dialog to enter the first and last numbers when the module is run? Let me be a little more specific. The db referred to is a Laboratory Information Management System that I have slowly built myself...

Thanks Gabriel, I checked that seems to be fine. It only occurs on occasions, i.e. if there are 6 records to append, 4 might be added and 2 aren't, it is very strange, it has recently got worse as the tables have gotten larger.

Hope someone can help! I was wondering if is possible to add a series of records that are in serquence to a table by just entering the first and last numbers. For example a string of numbers starting at TP11000 and ending at TP11100, the prefix TP doesn't change. Currently I have to enter every...

Hi, Not sure if anyone else has this problem or has already been answered. I have an append query that is supposed to add rows to a table when table A is updated. If you look at the query itself in datasheet mode, the data is there, but it is not appending to the table. This only happens on...