Search results

Hi all, I need to create a vba code to import 1 specific cell from an excel spreadsheet containing some currency data for each of my registered customers. The excel spreadsheet contain more than 60 columns so I am not willing to upload the whole spreadsheet. Having in mind that in the excel...

Hi, I need to create an excel spreadsheet with the data entered in my database based on 2 dates (start and finish) provided by the user through a form. My database is designed with FE/BE but there are no linking tables and I want to keep it this way. What is the best approach...

Hi all, I have a database splitted in Front End / Back End. I am trying to delete some specific records ("activityID") using VBA code in every table that starts with "tblActivity". The code I am using is: For Each tdf In db.TableDefs If Left$(tdf.name, 11) = "tblActivity" Then...

Hi all, I know this is a basic question but I haven't done reports/queries on MS Access for so long that I can't remember how it works!! :( I have a database built to record the activities of my sales team. One of the fields captured is the type of the activity for the day... it can...

Hi, I need to create some reports for the database I have created for the sales team. They are going to use it while on the road as well as when connected in the network. As their laptops are really slow I didn't want to include queries as this would make the database considerably bigger...

Hi all, Not sure if this question should be raised in this Discussion thread but it sounds as a design question so here it goes... I have a database which I have splited in Front End / Back End. I have around 100ish combo boxes splitted in around 25 forms. My question is, what is...

Hi all, Here I am again with more questions... hope that, as previously, you guys can shed some light!! In one of my forms which contain a lot of textbox fields, comboboxes, etc... I have a list box where I populate some existing contact names added previously by the user. As I...

Hi all, I have about 10 tables interlinked. Their name start by "tblActivity_..." and a common field is the "activityID". I am trying to create a code to delete a specific activityID from all the tables. I am using the following code where "rsActivity.Fields("activityID")" is the...

Hi all, What is normally faster (or best practice): to have link tables between the FE and BE or do all via SQL commands (ADO/DAO) from the FE? Thanks

Hi all, Please another pair of eyes would be great to spot what I have been doing wrong. Being too long looking at it that can't find what is going wrong. I need to copy my tables into another database but without the data. I am using: DoCmd.TransferDatabase acExport, "Microsoft...

Hi All, I have built a FE x BE database in ms access at work. It is OK and runs without major issues when the user are in the office using it through the network. Now I have been tasked to do an "offline" mode of the database to be used by some users on their laptops when "on the...

Hi all, I am struggling to find the best approach (pros and cons) to a table structure and I hope I can get some opinions!! I have to record (and be able to update) monthly individual targets for New Business and Renewal to all our clients on our 6 products. My first thought was...