Recent content by SeeWard

Ok...that does make sense and I really appreciate the time you took to jot that down...I have a tricky aspect though...I wonder if I can make that range grow if a new product is added. It's an inventory system, and they might get a new product in so a set range might prove troublesome in that...

Hello, I have created a userform in Excel and would like to have one combo box/drop down list be populated with data from 3 columns. Columns A B and E ...is there a way I can concatenate the columns so that they will not only appear in the drop down but also be saved to the excel sheet. I am...

Hello... What on earth does it mean when you get a message that states Disk or Network Error?.....I have a database on the server and it's split into BE & FE ...it's only happening on one computer...the rest seem to be doing well with it...

Thanks to you both! It works perfectly well and does exactly what I needed it to do!

Me again! I thought I should rephrase the question. How would I go about creating an update query that would update fields in a table based on fields in another table. I have addresses ...but these addresses contain the wrong counties. I have a table that has all the cities and their...

Hi, I don't know if this can be done in Access, but I would like to be able to update records that contain city and county fields. The proper cities and counties reside in a different table than the main table. Is there a way I can create an update query that would pull the right cities and...

Thanks John, You gave me the piece of the puzzle I was missing! Cheers!

Hello there, I have a table that was created by pulling in an Excel file. The issue is that there is that City, State, Zip, and County are....in one field. :( How can I break up the string so it is 4 fields respectively? Thanks

Thanks :)

Hi, Curious to know how to call a query from another query. I'd like to set up a way so that I can execute a series of queries (all apend queries) to simplify the process of apending data to a table... TIA

a friend has asked if there is a way to save a table so that it's sorted by last name....she says that it won't 'save' the design if she presses the the Sort button on the toolbar and then saves the table...Is there a way she can save the table so that it always comes up sorted? TIA

Thank you both Jim and Bob...this gives me much insight and direction! Many thanks!

Thanks Bob! I am just curious as to why you recommend optimistic locking rather than pesimistic locking? The records in question are constantly accessed every few minutes...I didn't realize one could specify in Access the type of lock other than record level/table level. How would I go about...

Hello, I've been reading that Access has a very myopic view of records. It tends to view a many records in one sweep. (???) If I had a database that was set up so that multiple users could have read/write access, how large does the record need to be so that I don't encounter locked...

Hi, I'm trying to create a very simple data entry form in excel that would capture various elemments of phone calls. I am utilizing drop down boxes to capture employees, call types, subjects etc but would also like to capture time and date. Is there a way to do this in excel with an input mask...