Search results

Thanks Meltdown.....that's perfect. Is there any way of filling the CodeID with a wildcard (*) rather than a 0? Thanks, Dave

Hi all, I have a combo box who's Row Source Type is set to Table/Query and who's Row Source pulls 2 columns of data from an existing table (UserID;UserName). I would like to set the first row on the combo to "*;Select All" and follow this by "UserID;UserName" for all users in the table. I've...

Thanks Pat. I'm already using the Join option so I'll stick with it. Rgd's, Dave

I have a fairly simple report which is populated from one table (TAB1). The records in this table have several fields containing employee id's. I would like to reference each instance of employee id in each record to an employee table (TAB2) and display their names in the report. The obvious...

Has anyone experienced problems when opening shared databases following the installation of Adobe Acrobat? I have Access 2003 shared db's which are accessed by users via a desktop shortcut. Adobe seems to force the db to attempt to open with exclusive access resulting in an error. I know how to...

Thanks SJ, reformatting the date did the trick. Really appreciated the help. Rgd's, Dave

Hi folks, I built a database earlier this year which involved users importing date based data. The destination data tables are linked tables connecting to a MySql database. To avoid duplicate data, a DCount is performed on the destination table's date field for dates equal to a given date...

Thanks Iagbolt...much better solution.

Just figured out the solution; 1. Calculate the pro-rata value (PRVAL)..e.g 2.6 2. Declare an int (INTVAL) and set it equal to int([PRVAL])...eg INT(2.6) = 2 3. Subtract INTVAL from the PRVAL...e.g. 2.6-2 = .6 (declare as double). 4. Run a select statement using the return from the above...

But what of the value is, for example, 2.9? In this case I would be looking for 3 come back whereas if it where 2.6 I would be looking for 2.5 to come back....i.e. the nearest .5. Int(2.6 + .5) = 3 (Should be 2.5) Int(2.9 + .5) = 3 (Correct) Int(2.6) + .5 = 2.5 (Correct) Int(2.9) + .5 = 2.5...

Hi folks, I'm trying to build a pro-rata annual leave calculator based on the starting date of an employee. I have it working but it's rounding the result to the nearest whole day. HR have asked that it calculates to the nearest half day. By way of an example, an employee who started earlier...

No problem Doc Man.....I spotted that and corrected. I tried it on Friday evening and it worked perfectly. Now all I have to do is get my head around the detail of the function. Thanks for you help with this. Rgd's, Dave

Thanks guys. I'll play around with the code code you supplied Doc_Man and let you know how I get on. Rgd's, Dave

Hi folks, I'm trying to read some records from an SQL database. One of the fields is an integer field though the data corresponds to a given date and time stamp. When the data is viewed through the vendors application it uses C++ to convert the integer to a legible date and time. The C++ code...

Thanks Doc. I should explain my situation a bit more. The table with the source data contains a list of employees, each with an employee i.d. Each employee also has a 'Manager' field containing the id of the employee to whom they report. When a given form is opened I want a listbox within to...

I've used dlookup to seach 1 field against a given criteria. The dlookup should produce multiple string returns. I want to store these returns in an array and later feed the contents of this array into a listbox. It's important that I have the array between the table and listbox so simply...

Hi folks, I've managed to get Shifty's solution up and running however, while it works it's very slow and would not be a viable for this reason. Does anyone know how I could tweek the code below to speed things up....maybe through the use of an array rather than table? Thanks, Dave Private...

Thanks guys for your help with this. A recursive lookup would appear to be the solution I'm looking for (Thanks for the code for that Shifty). I'm can't comment on whether or not the temp table is the most efficient method but it seems a good option for the moment. If there are any...

Hi folks, Another problem I'm hoping someone can help me with. I have a table with two columns. The first contains a list of employee id's (one for each employee in the company) and the second contains the employee id to whom the employee in col1 reports to. I would like to build a form with...

Hi Dugantrain, Sorry for not replying until now....I've been out of the office. I haven't had a chance to try the code you suggested yet but at first glance it looks like it will do the job. Anyway, just wanted to say thanks for the help. Rgd's, Dave