Search results

I haven't used Access much in several years now, so I am rusty on how to use it and also never knew the full ins and outs, so I may need a thorough explanation. I am hoping to clean up a 5+ year old database that hasn't been used for a while but they are picking up again. The database is split...

Hello, A user is getting a compile error that the code needs to be updated for use on a 64-bit system after getting a new computer. I don't know anything about this and am just trying to help out, but I appear to have a 64-bit system and don't get any errors. I am not well versed in coding but...

I'm building a database for work. I've got a good start, but I'm having trouble with part of it. This is what they want: Import a spreadsheet of accounts with missing documents (done) User will view the record and see if they have received the documents If yes, complete from database If no...

Hello. I have the following code to add the items selected in a multi-select listbox to the table. If item 2 or 6 is selected, part of the text needs to be replaced. The part in the middle where I have the If statements is giving me trouble. If I only select one of those items, it works to add...

Terrible title, I don't know how to describe it! I have a form that the user completes to create a report. This report is a letter that is sent to the customer asking them to provide a document. There is a multi select listbox with 10 options for the user to choose what they need. The ID of...

I have a form with a datasheet subform, which contains a combobox of documents to select from. They can add as many documents as they want. 3 of those documents require a notary, 6 do not. If the user chooses a document that requires a notary, Notary Required is automatically checked on the...

I have a form with a continuous subform that contains a combobox. I currently have code to enable some fields on the main form if a certain selection is made in the combobox. This is working, however, if a selection is made in a second combobox, it then closes the fields needed for the first...

I'm in a time crunch and am having trouble figuring out the best way to do this, so hoping for some input. Here's the scenario: The user goes into the form and needs to select from a list of documents. I originally had the "document needed" in a combobox in a continuous subform so they could...

I have a 2 part question I am hoping to get some help with. I should also add that I'm not very well versed in queries and I mostly stick to select queries, so I may need specific direction if another type is needed. I am building a database that imports a report of accounts that are missing...

I made a database for a team at work about a year ago, and it has been working fine as far as I know. Now there is a report that is pulling the wrong data. The report is set up as a customer letter, and most of the text is in a text box with an expression to pull in the address fields. It says...

I have a report for work that has 2 subreports. The report is a list of names, with the number of calls they took, the number of errors they had, and their error ratio for the week. I made a button with a macro to export the report to Excel so the numbers can be copied and pasted to other...

Using the second page of this thread (https://access-programmers.co.uk/forums/showthread.php?t=206372&highlight=outputto) I am able to export a report that is filtered by person and save it under their name and today's date, but it is taking over 5 minutes to export 3 1 page reports. There are...

I have a form with customer information. The information will be imported from Excel and someone will move through each record and add the provider information to it. There is a Provider table which holds the name and address. There is a combobox to choose a provider, which then displays the...

I have found several threads on this topic, and have found some code to get started with in this thread: http://access-programmers.co.uk/forums/showthread.php?t=206372&highlight=outputto&page=2 But after trying several tweaks, I just can't quite get it to work. I am fairly new to Access and...

I have a continuous form with all records from the table Main. It's purpose is for a supervisor to be able to correct a record if needed. Each record could potentially also have data on 2 related junction tables. I have added 2 Edit buttons on each record/row on the continuous form in case they...

I am working on a database that has about 15 users. Someone else added to it so that it will automatically detect the user ID so they don't have to select their name. Their name displays on the top of the main form where there are additional buttons to open other forms. The code is working...

I have a split database with a main table and 2 junction tables that should be related. I was having trouble with blanks in my table so I decided to make a new backend and remove the auto name correct and clean up a few things. The main table has over 30,000 records in it so far, and I was...

Hi all, I'm new here so I hope I don't do this wrong. I am self taught with Access and VBA and have been learning through trial and error and Google. I have created a database for work. It is split and there are 4 different front ends, each used by different people depending on their job. Some...