Search results for query: *

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...

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...

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

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

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...

Hello, There has been an incident where a table was deleted from Access 2003 .... the database was shut down so I can't retrieve it that way. Does any one know how one can recover a deleted table? Tia

Hello......... I have a database which is on the networt. Multiple people use this databse. I have it split and the BE in on a shared drive....Everything was moving along just fine until I encountered an error message "cannot update...currently locked"...it's opened in share mode with record...

Hi, I have successfully split a database so that all users can use it at the same time without too much hassle....I had it the FE loaded on all pcs except one. When I try to open it on the pc, it gives an error message of '<path> bad path...' ..the only reason I can think is that her pc is not...

I have created a database that is used by multiple end-users. When they try to access it, it tends to freeze and states that it's locked by admin...Any suggestions? Thanks SO MUCH...MANY THANKS!

Hi everyone, How does a person force a page-break on a sort field in a report?

Hello.. I am trying to fix an error in the database which spans three tables. I can get at the data I want but can't seem to change the recordset when the query is run. What I hope to accomplish is to change one field based on a conditon. If FieldA = -1 Then FieldB = 0 ..but I don't know how to...

Hi, Is there a simple easy way to just copy out the design of a table thereby capture it's name and datatype? I can't seem to simply 'copy and paste' the list of field names and types. It's a rather long list and I'd rather not have to type it all out......

Hi just need to know how to derive today's date (been using (Now()) but would rather not have the time stamp on it. I need today's date to automatically appear on the form yet be saved to the table. TIA as always,

I would like to have a form that will update tables dependant upon which field has data. For instance if a person were to enter in an organization name, I would want the organization table to be updated...if a person entered in the Client Name, I would want the client table to be updated. Both...

Hello All, Curious to know if anyone had ideas on how to make a cmd button invisible depending upon a page selection within the tab control? I have a subform that's recordsource is a different table than another other forms. *I've got 4 tabs 2 of which are run on the main table, and 2 that...

Hello, Could anyone please tell me how to have the tabs appear when an end user opens the form? I have the property set to always visible, but each time I open the forms, I have to either press the up arrow or move the scrollers up in order to view tabs...is there a remedy for this? TIA

Hello All, This should be a fairly easy thing to do I would suppose. I am trying to change the background color of the tab control on a form. I have the property set so that the back style is transparent, but yet the background will not fill in with the color selected. It still behaves as...