Search results

I understand. Many record are a simple yes/no type. This is almost like a check list where different disciplines need to have their input before we perform a job. The other fields are either data from previous job for reference or fluid properties or engineering calculation results. hope this...

Now the problem is that my table is larger than 255 rows...should I split the tables? Is there a way to have more rows? Thank you Enrico

it does, thank you

Thank you, now the problem is how do I automatically add the same ID to each many in the subtable?

Thank you. Is it a problem if some of the tables will contain a one to many relationship to another table that needs to be linked to the main ID as well? Master ID to Table one to one. Table to sub Table one to many

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

Thank you, Luckily I do not need to separate work days form week end or bank holiday. I would need to know how many days Holiday in May and how many in June similar for working day. The problem is when my date record is across the month, then I need to separate the days between the different...

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

Switchboard yes Thank for your reply, Yes, I do have a switchboard, as a matter of fact I was able to achieve what I wanted using a macro but it seems pretty convoluted and I need also to open a form for the check to be performed. Is there a code I could use to check the data? Regards

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

cheers to all That worked!

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

That worked Great, Is there a way for access to scan the odbc present on a machine? And present result in a table? Thank you

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

received tks Thanks I will try that.

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

The query works just fine now, and the subform too. The problem is that when I open the main form where the combo with two column and the subform are. Instead of opening the form and showing me an empty subform, Access asks me to fill in the value. Once I fill them in it works fine. It does not...

Thank you Yes the subform is based on a query. At the moment I have two combo boxes. With one you choose the "tool" with the other the "tool size". Once trhe two selections are made the subform shows the data filtered by "tool" and "tool size". I whish, if possible to have only one combo with...