Search results

I think i will switch back to the Acces 2000 file format! But i cant understand why commands like date() do'nt work! Maybe the version of Access 2000 i am using is corupted, but then in that case why would it work at all.?

Thanks. i dont want to combine the two tables into one. i have two databases, an old version and an new version. The table structures are the same. I wish to import the data from the old version into the new version. The two tables i need to import are linked by an ID field. Table A is the...

I have a message box pop-up on the before update event of my form. Only problem is i use a tabbed object with 3 tabs, the fields on one tab and two sub forms on the other two tabs. When i move onto the tabs with the subforms the on update event is triggered and the pop-up displayed. Does...

I have Access 2002 (set to use Access 2002 file format) and when i export as Access 2000 and use the exported file with Access 2000 there are many errors with certain commands. Date() does not work, changing to Now() fixes the problem. Left() does not work. eg. Left([gender]),1) gives M or F...

I have tried and tried and now i must try the forum :) I have two tables which are linked with an ID field. In table 1 the ID is an autonumber, in table 2 ID is a number. All records in table 2 that are related to a record in table 1 have the same number in the ID field. I can append each...

thanks that should work perfectly, but i need to display the frequency of values per unique ID field. ie. frequency of value 1 for ID 7 Best wishes, kris

Which SQL function is used to calculate the frequency of a paticular number in a number field. I have tried both count and Dcount but dont get the exact results im looking for. Using count i get the number of records, but not the number of records that contain, say, the number 9. Using Dcount...

combo box you need to make a new form, and drag and drop all the field onto the form that you wish to use. (or create an autoform). then delete the input box for company name and replace it with a combo box. If you have wizards installed and clicked to on, the combo box wizard should appear and...

In clause solved sloved the problem of file not found. the path was fine. when looking at the file in Win XP it is labeled pss.mdb therefore i thought fine the filename is pss.mdb but no, the label does not include the file extension, so the file is actually called pss.mdb.mdb so renaming the...

im having a problem with the IN clause, i keep getting a file not found error. The path and filename are correct, i even copy pasted the path and filename from the databases properties to prevent typo's. Any suggestions? Looks like im gonna have to learn VB :( @ Jon. I already use delphi and...

thanks for that jon, that simple, yet i have a advanced MS-Access book and it does not explain this. Maybe I need a dedicated SQL book? Is it possible to let the user enter the location of source database, like putting [Please enter value] in the cirteria, so you get a pop-up box where the user...

I am running into a of confusion with an append query. Basically i have a master database (destination) and many data entry databases (source). All the data from the data entry databases needs to be imported into the master database. I am having trouble specifying where the data entry database...

got my feet wet with VB and it works a treat... thanks Rich Now just gotta descide if to actually change the values in the field or use the function at runtime. kris.

Rich - im not good at visual basic :( so cant use that method Colin - i have tryed that, but the same orignal problem occurs. I created a new field and then used an update query to put the recoded values into the new field: Field: oldfield newfield oldfield newfield oldfield...

thanks, but the values in the fields actually need to be changed, it is for statistics calculated later on in another query. To preform the statistics query i need to reverse the values in the field. Sorting them in descending order would visually change the order but not actually. Best wishes...

I am trying to design a update query that will rearrange the values (a range from 1-4) in a field in reverse order. So 1 become 4, 2 becomes 3, 3 becomes 2, 4 becomes 1. I thought the way to do this would be to create an update query with the field in 4 times and the criteria for each goes from...