Search results

Thanks to both you guys for responding so quickly. Thinking through what you've sent me raises another question. If each table has the same numbering pattern, 1-270 as an example. Is there a way to go in and have the autoincrement change one of the tables to begin at 600-870 as an example and...

I have two tables of different structures. Both have sys=autoincrement as a unique record identifier. What is the best way to blend the two tables into one? Should I change the field structure of each table so that they match up for a file export and import and if so how do I handle the fact...

Is it possible to set a field in Access such that you can enter movies with a mp4 extension and run from there rather than having to do it from excel. Works fine in excel, but can't figure out how do so in Access. Thanks for your help. Ron Wells

jdraw: Thanks for your response. The link you sent to follow will not open for some reason. Would you try to send it again, my email address if needed is roncathyw@att.net. Thanks again. ron

I have a Client database table in Access. I now need to add a simple order table (related) to the client table. I have a client ID field set to autonumber in the client table. As I start to create the orders table I'm not sure how to link the two so that I'm not entering data twice and have...

:banghead: Is is possible to create a field in an Access table to hold and run MP4 video files. I've used hyperlinks in other tables/fields successfully, but can find nothing regarding using a link to a MP4 video file.

Pat: No such luck. I tried ever combination I could think of to try to get it to look up the mainform data from filtering on the subform. It finds nothing. Do you think there is another way to go about doing this? Could I possibly send you a copy of the file to see if you might see a way to...

Pat: Just to reiterate for clarification, we have a main table (AIM Prospect Listing Table) which holds dealerships throughout the country. That is very helpful in making contact with the dealerships. It would be very beneficial to have the ability to log a phone call as it is made, together...

Pat: From your perspective would it be better to have these two tables joined by a link in Relationships" or joined with a query. I surmised when I began this that joining them with a link in relationships what the appropriate action. However now that you've asked me to provide information...

Pat: After I finished the above post, I realized I should show you a query joining the two tables I mentioned above. When I went to the SQL area this is what that shows. SELECT [AIM Prospect Listing Table].IDDealership AS [AIM Prospect Listing Table_ID Dealership], [AIM Prospect Listing...

Pat: Thanks a lot. I got your info and got to the SQL area your info explained and then realized that what I have is not running from a query at all but is two tables linked in the Relationship area. Therefore when I attempt to get the SQL info you asked about, It doesnt even resemble the...

Pat: Thanks for your attempt to help me. As I said before I'm such a casual user that I'm not even sure I'm capable of answering your request for information. If you don't mind my asking, how do I go about opening the querydef? Thanks again, Ron

Plog: Thanks for your attempt to help me. Unfortunately I'm such a casual user that I'm not even sure I'm capable of answering your request for information. About the best I can do is a sort of reiteration of my original post. We have a listing of auto dealerships in a large flat file Access...

:banghead: I have an Access Table with about 28,000 Automobile dealerships across the country shown. I've joined a new/small phone contact table to this to keep up with our phone contacts with the dealership and followup efforts. When I search/filter on the dealership table all is fine. However...

Alan, thanks for responding. For example, one file might be a person's initials, another file might be today's date, another filed might be the publisher of a book etc. Instead of having to type out the same data time after time where appropriate, I'd like to be able to assign a sequence like...

I have a need to input repetitive data directly into a table. For example, Ctrl-C gives me the abilty to copy the data and then Ctrl-V wherever needed. I have a need to do similarilly on other data. Would a macro work for this or is there a better way? Thanks :confused:

I appreciate the attempt to help but you must be responding to the wrong request for help with your answer. At least it does not appear to be on subject for what I'm interested in. Thanks anyway.

I have a table of research books. We have found many duplicates and want to sell them. I've copied the items for sale to an excel spread sheet and sent half to one associate and half to another associate off site, to get their assistance in researching and pricing the for sale items. When the...