Search results

I think I've found the problem. The clients whom I've designed this database for, were linking to the same FE instead of it being on their individual work stations. Thanks everyone for all the help.

Hi there, Sorry it took me a while to reply here. I've been out of the office. I've gone directly to the BE and had two computer go in at the same time and they were able to edit the information without any problem.

Thanks a lot for the response. I have given each of the users their own FE. But when they open the database and go to modify or make changes, it locks them saying they can't make any changes. or that it won't save the changes. I have looked around the forum here, and there were quite a few...

Hi guys, I'm having some issues with a database that I have created. All this time only one user would be in the database. But now I have 2 to 3 people at a time in the database. I get an error and its not letting the users put any information in. I have it split into a FE and BE. I have...

Hi there, I got myself pretty much backed into a corner here. I am trying to add images to records. For example, in my database there will be certificates scanned and put on each specific record. I have been searching high and low and found that the OLE object tool will allow me to do this...

Your not supposed to store values that can be calculated, but if u are u can use an update query and say something like Elapsed: EndTime-StartTime in the update to line i think.

Hi there, I'm trying to add an image into a table. I know I can do it manually by creating an OLE Object and so forth. I am actually trying to get the user to enter in the path of the image and add it into the record/table. Basically this is for a database that will hold a scanned image of a...

Hi there, I'm trying to add an image into a table. I know I can do it manually by creating an OLE Object and so forth. I am actually trying to get the user to enter in the path of the image and add it into the record/table. Basically this is for a database that will hold a scanned image of a...

Thanks a lot! That bit of information was helpful for putting me into the right direction to come up with some answers.

Thanks a lot for the code!! It really helped me in the right direction. Now I'm just trying to create a file browser which will allow the user to go and point at the directory instead of manually typing it. Thanks again!!

Hi there, I'm trying to import data (CSV File), which will contain only two fields (ID Number, Comment). I want to create a macro or perhaps VB code which will simply import the two fields into a table and simply enter today's date in the date field and write the comment that I'm importing...

Thank you very much for pointing me into the right direction. I actually created a macro which simply shoots the information out into a CSV file. Thanks again Thevaker

Hi there, I'm trying to store the results of a query into a CSV file. This query will only have one field present. I know I'm able to export it into Excel and from there on save it as a CSV file, but I'm hoping to have a command button so that when the user presses it, it will automatically...

Thanks! What your saying makes sense to me. I just gotta find the syntax to specify the record source I guess. Another issue I am having, which is somewhat related to this is that, when I add a new record for the same customer (i.e., have the customer in there twice for different incidences)...

Hi there, I'm sure there is a simple command that needs to get written. But basically I am trying to print the current record that is open in a report. Its right now printing all the records into the report. I'm sure its just some parameter I need to type into the print command line, but I...

Unfortunately I have no one to login to this database. I do not get an option to enter a username or password for this database, it just goes straight to that error message.

Hi there, I tried your method, the option I think your talking about is 'Find a record on my form based on the value I selected in my combo box' When I do that, its giving me the information of records I have of the current form, not the table which has all the addresses. I would very much...

I have an old Database which someone had created and they stopped using it. Now they would like to get the information from it. The problem is whenever I try to open it, it says 'You do not have the necessary permission to use the c:\SGSS Database.mdb object. Have your system administartor...

Hi there, I've been working on this issue for quite sometime. I've tried different methods, such as the DLookup function, but I think I'm doing something wrong. Let me explain what I'm trying to do: This is a Work Order, the user will Select a Customer (Table Customer: Contains CustomerID...

The reason I am trying to save the value into a table is because there are many errors that pop up when I try to recalculate the field. For example, my calculated field calculates cost*Percentage+Cost = Selling Price, this is the price that the client will see. These are for parts in a...