Search results

Fellas, thanks for the help so far... I have tested it and it is working perfectly!! But from one question to another... I am using the following SQL code to create my query: SELECT tblSalesTeam.firstName, tblSalesTeam.surname...

thanks Arvin... I had seen your thread before posting mine but at the time I couldn't figure it out what was happening ... Anyway, used your code as base to create my query and it is working!! Now another question, I want to create it based on dates entered by the user through a form... how...

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

DCrake, I have a FE/BE in the network drive which the user can go and create the offline version (the offline version is a copy of the network version but the FE is without all the administration functions and BE is without all the data related to other sales people making it "slimmer". Then...

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

Cool. I haven't thought about it!!! Thanks mate!!

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

Great!! I will try it and let you know!!

I understand where you come from and I appreciate your help but this listbox will have a maximum of 4 or 5 entrances and it is only editable so users can delete any wrong entrance in a period of 1 day, after it the fields will be disabled for changes, also the form itself looks quite cranky and...

Again, thanks for your reply... You mentioned: "My point is the button should remain Visible if a row is selected in the listbox"... yes this is exactly what I want that the button just appear when the list box has a selection but also that the button disappear if the listbox loose focus (so...

Hi vbaInet, Thanks for the reply... My Delete command button is hidden/invisible when nothing is selected in the list box (when form is loading I hide the delete command button) and when I click on the list box it appears ... the thing is how to run the delete command button and make...

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

Thanks Galaxiom... it worked perfectly when I changed the recordset to a variable. And nice tip about the recordset!fieldname, makes it a lot easier. The comments, unfortunately I need to add as I am leaving soon and the person who will be taking over don't have much knowledge of VBA so I do...

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

Tried with the True instead of -1 and without the MS Access, same error message 2507... Could it be anything to do about the tables being linked?

It comes up with an error (Error 2507 - type isn't an installed databased.). Tried adding the "Microsoft Access" which was not included in your code but then it copied with all the data instead of only structure!!! Any other thoughts?

Hi James, Tks for the reply but I really can't see where there is the missing comma... Just in case, based on the link you sent I have tried the following: DoCmd.TransferDatabase transfertype:=acExport, databasetype:="Microsoft Access", _ databasename:=laptopDBSource, _...

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