Search results

To who can help, I have a master ID [IPWP_ID] that needs to be repeated across multiple tables to be able to create a report with data from al the tables. Somebody will set up the first entry then I would like for a record with a Master ID entry to be created across 7 different tables. Various...

Good Morning, I have a table where I record period of time: Example: ID1 from 25-apr-06 to 06-may-06 Holiday ID1 from 06-may-06 to 02-jun-06 Work How do I automatically calculate how many days ID1 was on Holiday and how many days was workign in may? Any help appreciated Enrico

Good Day! I have a simple table where the user enter expiry date for visa. User also enter return date of visa holder. I am looking for a way whereby, every time I start my database a report is automatically sent if Visa Expiry daye is close to departure date. I already have the query and...

Hi, I got some numbers stored as text in a query. I need to do some simple math on those number. How can I convert text to number automatically, without going into the table design? Thank you

Hi, In two different table, I got the TEXT data below to compare. What I would like to do is split the text in 3 columns so I can then subtract the numerical value. Is that feasable? S6 32 41.996 S6 32 41.9962 S7 53 15.903 S7 53 15.9039 S7 54 09.694 S7 54 9.6948 S7 54 17.781 S7 54 17.7814...

Hi, I link 4 tables from an SQL database into access using the access wizard and choosing the relevant ODBC connection to link to the sql database and pick the table I need. My problem is that I would like the access db user to decide which SQL database (there are multipe dtabase into ,my SQL...

HI all, I am using access 97 and from my forms I make extensive use of the Office links button to export excel table. Might not be too elegant but it is quick and easy. I am wandering, can I change the default location of where the file is saved? Thank you

HI All, I am importing in access and excel various bits and pieces of a SQL database. The issue here is that all data stored in the SQL are in S.I. and I need to perform unit changes. I have linked the table I am interested with in acess and I am performing various query. I would need to...

I have this combo box which has two colum: tool and tool size. This combo controls a subform linked to "tool". I was wandering can I sort the data in my subform using both the column in the combo box? Thank you

Is this feaseble? My table are on a server linked to the user FORM, Queries ETC. The server, is somehow slow. I was thinking: is there a way to have all user to have all the DB in their hard drive and only refresh the new data I will put on the server each time they open their database? Thank you

I can now import data in my table using the transfer spreadsheet macro. I would like to set a simple validation rule in my Field that contains number to make sure the value entered is really a number and not something else. Thank you once again for your help!

I am populating my database with data from an excel spread sheet. I am now importing the data by cutting and pasting them in a table. I would like to be able to import the data directly from the excel spread sheet, without opening it. I have found out that there is a macro to do that but the...

Thanks also to the people of this forum I was able to come up with something nice and useful. I then discovered access XP pivot chart feature. I installed Access XP over access 97 on my computer at work but it doesn't work. I cannot drag and drop field as it should be. I can only see the...

I have this query that works, for once properly. it is a date query. it finds records between two dates. I used criteria of: Between [Type the beginning date:] And [Type the ending date:] in the criteria field. Now I have to put in the date manually. Is there a way to have drop down menu or...

I have spent a long time trying to do this but no chance I would really appreciate some help. I have a form in which there is a subform. Two combo boxes control the subform. One queries the subform by WellName the other select the desired subform Es subform with geological data, subform with...