Search results

Hello! I have two tables Table1[Date,Time,SenderID,SenderName,ReceiverID,Re ceiverName,Type,Direction,Location] Table2[Date,Time,SenderID,ReceiverID,Type,Directio n,Code,Reference] How can I merge theese two tables into one table/query with all the coulumns included like...

And how would the syntax be with 2 tables/queries? And what about field names? What will they be? ...Well i found out =) I got rid of the () and the field names solved by Select As Thanks for your help on a Sunday =) noccy

Well....Find the right forum and hit the new thread button....

merging multiple queries Hello! I have three queries with the same structure. They all have two culumns, named ID and Adress. Can I merge theese three queries into one fourth query containing all records, and how? noccy

Did it =) Well I used the references as you said, but I had to use the Full.Path to find out the Office version. The final part of the path to MSO.DLL would be Office10\MSO.DLL, so if the 10 last charachters are 10\MSO.DLL the version would be right i guess...... Dim ref As Reference For...

tnx =)

Make a query like Mile says, and use the Transferspreadsheet method to export it. ah... too late =)

and how do i find the references? =) lol sorry for beeing noob

Hello! I'm building an access application, and on startup i want to check some system information. The things i want to check is: 1. Office version (not just access, but word and excel too) Basicly I need this to make sure the user has the Office 10 Library available 2. Windows Mediaplayer...

Hello! I use this code to import a list of text files to my db. It works just fine, but not when the filenames had a . in the middle like 001.test.txt Any suggestions on how to get by this problem? For i = 0 To Me.Liste39.ListCount - 1 varFile = Me.Liste39.ItemData(i)...

Hello! I have recently worked with Word documents as objects in vba. I have imported data from Word to access by creating arrays. Is there a way to work with text files using the same method? Lets say I want to get data from a line in a text file beginning with "Test:". How to I find this...

Has anyone made their own Find and Replace Form? I tried to do so using the replace function, but couldnt make it work.... What i need is a for that allows the user to search for a part of a field, and replace it with something else: Eksample: Old value: Hello New Value: Hallo e replaced with...

Hello! In a subform I have a form viewed in Datasheet mode. I can edit the data manually, but when i do a Find and Replace (Crtl +H) the changes seem to happen but only on screen. When i close the form and reopen it, the changes have not been made... Any settings keeping me from using Find and...

help! hehe didint understand much of that =)

Hello Is it possible to open a specific form with a WHERE condition from a batc file? Let's say I want to open the form frm1 in the database Myby.mdb, and show all records where field1=0, and do som by running a batchfile... Possible?

hehe as I said i had thougt of both methods, and asked about both as well :D tnx m8 =)

tnx m8 =)

yeah, i thought of that, but i dont know how to ask for a certain number of charachters........ noccy

hello! How can i make a query with a WHERE expression that counts the number of charachters in a field I would like to find all the records in a table where the number of charachters in "Field1" is between 250 and 260 suggestions? noccy

Hello! In a table I want to find all the records where a certain field contains exactly 255 charachters. The results I want to put into a new table Any suggestions? I was thinking something like a DAO connection with an sql string to find the records, and then a With.rst........ to create a...