Search results

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

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

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

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

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

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

Hi there, I've read through the forums on saving the results of a calculation into a field is a bad idea. I somewhat understand the reasoning for it. But I don't think such situations arise for everyone. But I have gone with the suggestion and created an updatequery, which simply goes...

I have a form which basically has a subform in it. One displays the customer's address, contact info, name, etc. The subform contains the detail information of what they've bought, how much, etc. Now I'm trying to print off a report that displays each customer on new page with their details...

Is it possible to run a query/filter in order to hide/show a field in a record instead of it affecting the entire record. What I'm trying to do is, in a form the user can enter information about a service call and they can enter a recommendation for the next visit. When they enter a...

Hi there, I am fairly new to access. I have searched high and low for help on this particular topic. Its something pretty simple, I just don't know exactly how to do it. Basically, the user will have a client selected from the main form, when they hit the button to go to another form which...