Search results

I think you are missing the point of linked tables and how they work. Have you created a relationship between these two tables? Do you have the same fields names within both table design? i.e. user name etc. You must have a link between both tables, so i am taking that you have a field...

Change you code in the report to Private Sub Report_NoData(Cancel As Integer) MsgBox "There is no data to display" Cancel = True End Sub You should not need any additional code on the form at all, if the report has no data in it, it will display the message, once ok is...

The easiest way to do this would be to insert fields into the relavant tables, and make there default values what you use at the moment to work out commission etc. You could hide these fields, to certain users and show them for people who coul dalter the value. But the admin person could also...

I could do with getting a nit more information off you if thats ok when you say row 5 column 3. It sounds like you want this to be executed in excel and not access. You are using access? If you are using access, and then you want a certain field within the database, after it has been...

you could have the main mdb file with the table in a central location. Create another mdb file, where you forms queries report are kept, and then link this to the other mdb file. Then create an mde file of this mdb file, and post that out to the users. This way you can make changes to the...

so let me get this right, you want a list box on a form, that the user select one or multiple records, click on a button, then a form opens up with just what they have select in the previous list box... Is that what you need...

it it only numbers within this field? If so what i would do is take the value 12-3456-78-90 or 12!3456 78?90 and make them 1234567890. Then if there is two number at the start, then 4 then 2 then 2 at the end you can re-format all of them in 2 procedure. The 1st would be to remove all...

the first suggestion would be to get all the PIN number in the same format. You could use a simple find and replace with excel the erase the spaces with a "-" symbol. To update a table that you already have in access with an excel file. You can either import or link the file to access. If...

unsure if this is exactly want you need but you could use DoCmd.GoToRecord , , acNewRec

you could have a simple table with 3 fields: IDNumber - Autonumber Carrier_Name - text Notes - memo Once the data has been entered, then you could have a form with a text box on it, you enter "Texas", the write a query that searches the Notes field for all carriers which texas in it. I think...

I do know how to do it, but i would not be through a macro. You could also use the replace function. But if you have a text box that could have different characters, then I would probably be best to use a module to do it for you.

I do know how to do it, but i would not be through a macro. You could also use the replace function. But if you have a text box that could have different characters, then I would probably be best to use a module to do it for you.

use a list box instead of a text box, it will work then.... Hope this helps. You can make the list box look like a text box, or you could put the headers on, instead of using a label next to the text box. Any more issue let me know.

use a list box instead of a text box, it will work then.... Hope this helps. You can make the list box look like a text box, or you could put the headers on, instead of using a label next to the text box. Any more issue let me know.

I believe i have corrected it to how you want it, let me know if not. Have a good weekend (Attachment removed by admin at member's request.)

you could if you want instead of it opening up the search form, select each individual form seperately, and use the search text box of the start up form, and a search criteria if you wanted. Do you mean that???? Thats even easier to do.... Let me know, cause I from the UK, and I leave in the...

I have done something, unsure if its what you wanted. Because each table is different i could not combine them all, i had to keep them seperate, hope thats ok. It all work, let me know what you think (Attachment removed by admin at member's request.)

if you could convert it to Access 97 then re-post it, then i will do it for you. Sorry if I have confused you... Once i pick the new file up, i can get it back to you within half hour...

OK. A union select query works best when you are combining tables together that have the same field names, so the correct information from each tables displays underneath each other, rather then side by side, as a normal query. Another idea, just thinking about it, you could have a tab...

so i am assuming you are using a union select query to join all tables together. Unsure if you are lazy when writing queries, if you us the build, or write diretly in sql. But the lazy option, create a new query, insert the one you already have (the union select one), then insert each field...