Search results

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

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

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

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

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

I have an applicaiton with Access Security. I have a group called Employees that I have limited the access to certain tables to read design and read data. I just added, at the last minute before production, a form with some code behind to relink the tables if they arn't in the location last...

I have a report that works fine except that I want to show a reference in a control on the page header to the Month/Year the records were completed. I currently have the code below in the report. It works fine on the second page but not the first... which sort of makes sense to me because in the...

I have set up a query by form to filter records for 4 reports. It works great... expect, now that I thought I was done, the client has change the rules... For one of the reports there is a field in the criterial that she only wants the records if it is null. Unfortunatel the sql for the query...

This is my first experience with Access Security. The Security was built and applied before the database was split using the wizard. I have moved the back end data to the LAN and plan to put the front end and the mdw file on each individuals PC. This doesn't seem to work because I just checked...

I know that the order of the records in the db shouldn't matter, but I am curious... Why, when I add records through a form in Add mode do they add to the top of the db rather than the bottom. Is there a setting or switch someplace that I am not aware off? Is it just the way it works through the...

I wish someone could point me to a resource that could help me understand the Object Brouser in Access. I am trying to figure out how to set a global string variable equal to the Access Security User Name. I can find in the brouser that Library DAO, has Classes Workspace, Document, and...

I am creating a new MS Access application to replace a very old DOS app (1984). It has a field called Form Number. I exported the existing data and imported it in Access. This field comes across as a text because in contains not only Forms, like 1,9,20,340, but also forms named 99R and CS2000...

I have been asked to develop an estimate for a call-tracking database. It sounds like it may be too large to be effective using Access and might be better with VB and SQL Server... or a canned package. Does anyone have an recommendations or sources of information that would provide Realistic...

I have added control tip text and status bar text on the properties of the fields of a subform but it doesn't show up. Any ideas why? Doesn't it work on a subform?

What is a 'user profile' and how do I create one? What I am trying to do is set the default Access 2000 Options for Keyboard behavior from Behaviour entering field 'select entire field' (which is the dumbest default I can imagine unless you want people deleting things all the time) to 'go to...

Pat... you are so awesome... I really appreciate your answer to my questions at http://www.access-programmers.co.uk/forums/showthread.php?threadid=29917&goto=newpost I need to clarify something though... The tables for my form, subform, sub-subform do have relationships designed in the database...