Search results

Hi there experts, I'm trying to create the form from the link pasted below. I want to issue a user database FE/BE to 3rd party user who will only have runtime. We will both have to update the BE and email it back and forth with changes replacing the old file in the users same location. The...

Thanks for the response, though this wasn't the method I found suitable, I thought I would leave a post that described a solution. Ken Snell has produced a great range of vba sub procedures for importing and exporting to excel that are well known I think. Amongst them is this; Write Data From a...

Hi Guys I am not an expert and I need help to export an access "test" table or perhaps the recordset to a generic .csv file that already exists. I am not sure how to approach it but I have had some success exporting dynamically to excel before. The data has 4 columns that need to start...

I Know I Know, its a hobby with me and I have started to put some of it into practice. I've read a few things on this one and I think the best route would probably have been to link the tables but I don't think the user will be able to use my network so I would be emailing the BE. Oh...

Hi, I am by no means an expert and all I know is what I have taught myself. I am creating a db to micro manage elements of projects I work on. I have an unbound form which I found and adapted online. On the form there are 2 buttons and a text field. One button runs vba code and opens a...

Thanks very much for your reply, I returned to this just yesterday and with some tweaking to the input SQL I've been able to simplify the recordset so that it only needs to start at the range (C:10) and this has provided me with a more straightforward solution. Although I got it working to a...

Firstly, thanks very much for your informative replies, To be honest the reason for posting to an Access thread with this one is because the db leads my project and results from some difficulty in doing this the other way around(exporting this from Access to the Excel range). The spreadsheet is...

Hi Guys, I've adapted some code I found which works and allows me to import data from my access table "Device Text" to a specific range in an existing excel worksheet by copying a field "TextEdit" in the recordset. the code is placed in a module behind a command button on an excel worksheet. I...

Ive read the Recordset tutorial and I'm going to use your example to update my Devices Table, I will probably get stuck but I like to persist because I get the experience. I imagine learning all this to be like learning to speak mandarin! Thank you very much for your posts I may need the help...

Hi, and thanks very much for your reply, I'm not too familiar with the concept of recordsets but I can read through some of the lines of code that you have used. I teach myself and know a little of most of the concepts, I do find Access and VBA fascinating, could you walk me through your code so...

Hi Guys, I've got a table [Devices] with some number fields that are already in there for another purpose. In a different exercise I will manually collect more information from a layout drawing and give each piece of information I collect a unique reference(this could be as simple as a...

Hi Exprort Experts! I have a subform with a combo box selection field among other fields. Can I export the data showing on the subform together with the drop down combo box data for each record and all its choices so that it appears as the same combo box on the worksheet. The user will then...

Thanks! I set out with select queries but couldn't query it out before, you have forced me to have a little re-think! Can I come back to you?

Hi, I'm looking for one of you nice experts to put me on the road to solving this. I've got the separate action queries to run but as you might imagine thats all too complicated. I'm not sure how to start I'm a little familiar with code but writing it isn't always straight forward. Thanks for...

Hi, I am sure I am missing something fairly simple here? I have 2 tables called 6000EquipmentDetails and Order Details, They share some common fields but are not related. The 6000EquipmentDetails table shows project equipment details, all the ID fields are foreign keys in both tables. ProjectID...

Thanks for your reply, sparks80, I dont feel this code I put in the Before Update Event of the "Sticker_Barcode" form field?? is far away. Device_Lead is my ref for FirstTwoDigits. this returns, Runtime error 3075, syntax error(missing operator)in query expression. Device_Type '6000MCP/WP' What...

Hi Everyone, Self teaching and fairly new to this, I need some help with validating a field in a form which will hold a Barcode reference(not the Barcode active x) which will be scanned in. The first 2 lead characters of the 8 digit barcode ref which can be a combination of numbers or letters...

Big Thanks Speakers 86, Most of your comments are bourne out in the stuff ive looked out so far, its nice to have that confirmation here. Normalization jumps out though and I will study that next! I am afraid ive bombarded myself recently and found out a little about an awful lot. Im gonna keep...

Hi, Newbie working my way through several needs on a form called Device Input Form created to fill out a table called Devices. On the form I have a combo box called Device_Type. I also have a text field called Sticker_Barcode which will be manually filled by a barcode scanner. The barcode's 2...

Fell into access 2007 a few weeks ago guys, after finding limitations with excel in a project database Im trying to develop. Since then I have read some dummies literature ,watched tutorials and generally gone backwards (mainly) and forwards trying to build code into related tables I have...