Recent content by MelB

I am linking to an oracle db that has a duration value I need but it is in milliseconds. How do I format or convert milliseconds to hh:mm:ss? Thanks in advance....

I have a field in my database that contains text and is 180 characters. I need to parse it into 3 new fields no greater than 70 characters each and I must divide the original text on the spaces between words. I know I have seen this done but can't find it anyplace. I would appreciate any help or...

I am trying to use one Access 97 mdb file to attach to two different SQL servers depending on the situation, one is production the other is a backup server. (The application requires an Access97 file format so I can't change that) I have a DNS Alias for the server name and I put that in the ODBC...

OK... I think I understand what you are saying but I guess my example wasn't very accurate. In reality, a person might go in and out of a secure area 10 times a day. So I can't match up the person and the day because there will be multiple entries/exits per day. I figured out how to this in...

I need to create a sql query to find the difference between 'time in' and 'time out' of a building... but unfortunately both the times are stored in the same field. I can't change the database design because it is propritary. The backend database is SQL and the fields I am working with are...

Thanks to both of you. I tried RichO's first and it works great. Thanks!!!

I have a form that drives a query for a report. There is a combo box with three choices for a field to filter on. It works great, except that now that the user has seen it, he wants the combo to have an option for 'All'. I used a Union query to add 'All' as an option but now I don't know how to...

Thanks but... Thanks but I need to summarize the quantities. There may be 15 locations in the first mile and they all have different quantities and I need the total for each mile in the report then identify the maximum. Maybe I don't understand what you are telling me but I don't think the...

I am looking for someone with expertise on queries and vba. I have done some of both but I am Not an expert. I have found queries to be easiest but I haven't been able to come up with anything on the problem I am working on. I wonder about a crosstab query but I have not done one before. Here is...

I guess I am not sure how to do this. I have a form, based on a query, that filters data to one of 7 divisions whe the form opens. On that form, I also have menu bar with the 'Filter by Form' and 'Toggel Filter' buttons. I would like to Export the current dataset, including any additional filter...

to quote you Doc_Man... 'that is not a comfortable solution'. Any other thoughts anyone?

I have a table which contains data from seven plants. I have a form that filters the data to their plant when they open it from a button. I have a custom menu with 'filter by form', 'toggle filter', and 'analyze with excel' to allow them to further filter their records then export them to Excel...

I know that dlookup is not the most efficent function, but in what I am going, I think it will work best. I currently have a form that has about 60 fields that each contain numbers (picture an excel spreadsheet). There are hundreds of records for several different plant sites and so I set a...

They are... I'm sorry I wasn't clear. I have a back end data base on the LAN drive. I created an mdw file and put it in the directory so it couldn't just be opened by someone who was just curious. The front end of the application is loaded on each individual PC with the mdw file that pertains...

They do have the correct network rights... I checked that. I have two seperate mdw files. One is located on the LAN drive to stop unwanted user. I used the instruction on this post... http://www.access-programmers.co.uk/forums/showthread.php?s=&postid=110487#post110487 THe other mdw file is on...