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

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

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

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

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

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

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

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