Search results

Hi all, I have a program in which I would like to open an access database (which has a form on open). however the code I have only works every second time I run the code, and to be honest, I have no idea why. I have tried multiple things, but none of them work (any more than every second try)...

Hi, I have a program that on a button click runs a query, and on completion decides to send an email to a recipient based on the amount of results. However its crashing on trying to open the recordset, I have no idea why as I use an alomst exactly the same code segment in many of my other...

I am having multiple user problems with access 2000 quite frequently, and I thought that replication would solve this, as it stands however its proving difficult to get my hands on the developer edition, just wondering, is it worth the hassle to get it, or is there an effective alternative to...

Hi, I should point out this is my first time creating a report I have a report that runs a query that gets data based on the entered year, it works, until you check 2005 Once you do however the report throws up an error because it cant find any data for months 11 and 12 for 2005 and says...

I am running a vba macro in excel reading through the list of data (3000) large and checking dates, if the current dat is the same as the previous date it needs to store the corresponding value, and so on until the date changes, then average the stored values and output it on the first one, and...

Hi, I have a crosstab query I have set up, calculating the cost of a product per month it should look like 1 2 3 4 gek22 £55 £66 £77 £88 er44 £99 $100...

I have a query that I want to run at about 10pm every night (when everyone has gone home) , to make it even more complicated it queries from sage and creates a table each night (that i want to overwrite the old table) and it will need to enter in the sage login information :( Does anyone know...

Ok, this might need to be in the macro section or something, but just incase, I have a query that I want to run at about 10pm every night (when everyone has gone home) , to make it even more complicated it queries from sage and creates a table each night (that i want to overwrite the old table)...

Hi, I have a drop down menu that is linked to a query it goes *table1* *Table 2(linked via area)* Company no+Company name+Area+Zone+Roundtrip distance Now the field that it stores is the company number (we deliver to the same company in differant area, so I...