Search results

No writing the start number is not working, It is as if the first thre digits of the number are being ignored!? I don't know how to stipulate a start number within the code, it was the reason for having an autonumber table to stipulate the start number. Ahhhh! Why is it doing this!

HI All, I have used the code Dennisk kindly gave me (amended slightly), but I cannot get the full number to appear in my required field. The table that contains the Autonumber, goes up everytime I enter new data in the other table, but the number that appears in the required table just goes...

Man I thought this would be simple, but it quite clearly isn't! I have a .csv file that contains around 250 email addresses. I simply want to import these into an Access table, each email creating a new record! NO using the import function only seems to allow you to import data as long as...

Man I thought this would be simple, but it quite clearly isn't! I have a .csv file that contains around 250 email addresses. I simply want to import these into an Access table, each email creating a new record! NO using the import function only seems to allow you to import data as long as...

Yeah thanks for your input, I did laugh a bit when I saw you were called Stallyon and your post talks about: Lead, Pencils and Missiles! :D

Yeah you can, but if the horse is not familiar with the taste of the water then you can't make him drink it! I did set a breakpoint, you're instructions were spot on. Thing is I don't know much about VB or programming code and so I have no concept of what it was you were talking about! What the...

Thanks Lagbolt, Sorry but as I say I am well new to VB and Access and so all the debugging stuff currently flies over my head! I am pretty stuck with this now, I don't really understand what's going wrong! Is there an easier way to create a Search form? That a mere mortal like me could do...

Thanks Lagbolt, but if I make the cnages you have suggested I get a new error: "Run Time Error 3075" Syntax error (missing operator) in query expression 'True AND [Related to Project Number]='. My code no looks like this: Private Sub btnSearch_Click() ' Update the record source...

Hi All, First off just let me thank gromit for posting the search form example in the sample database forum. I have used this to try and create my own little search form so I can query a table of data. But I keep getting the run time error 3131. There is an issue with my FROM clause. I am...

Hi Shane, thanks for the quick response. It turns out that the actual control was still called Combo58! so I changed this to Tool_Location and that requery now works a treat!!!! Thanks so much for your input, I have learned something new! Thanks for the tip about the naming convention. I...

I am trying and have used that code: Forms![frm Tool Data]![Tool Location].Requery but now I keep getting the following error code: Run Time Error 438: Object doesn't support this property or method

Umm just had a quick fiddle and I am not sure how to do what you suggest. I can see that you can create a Macro for the On Close event, that has the requery function, but I cannot see how to direct the requery to the cmbboxes that I need it to requery!? I do not understand what the control name...

Hi Shane, Thanks, I hadn't thought of it like that. I will give it a try. I am just learning about queries so this should be a good exercise. I will definately let you know how it works! Thanks,

Hi All, I have looked through various threads and have not found an answer to this one: I have a couple of fields on a form that take their values from a separate table. The fields are locations. If the user cannot find the location they need in the lookup, they can click a button to add their...

Thanks SJ, It does make sense, kind of. I want to query this data though from outside the form. So I need to figure out how to do that. The whole point in having this data calculated is so users can search for tools that need to be refurbished or re-tooled within the next 24,12 or 6 months. I...

Dear all, I have the following form that records tooling data in a tooling data table. I have the following fields: -Tool Life TOTAL (in parts) (entered by the users) -Tool Life to Refurbishment (in parts) (entered by the users) -Monthly Quantity of parts off of the tool (estimated) (entered...

Thanks guys for taking the time to reply to my thread. I understand now that gaps may appear and to be honest it is not a major issue. I would like everything to be driven off the database it self (for example the order is printed from the database as a report rather than the user manually...

Dear All, I know that there may have been many posts on this and I have searched for a total of about 2 hours in these forums before posting, so please don't shoot me down for asking this. I simply need to know how I can create a unique, alphanumeric order number. I was going to use...

Thanks, that has worked. I appreciate the response.

Hi All, This is my first post so can I just say how great and useful this forum has been for me since I joined! I have found pretty much everything I have wanted without having to ask, so thank you everyone! I am only beginning with Access at the moment, as I try to implement some improvements...