Search results

Since its online you can create a path to the Excel sheet and open it.

Instead of tables I could open>change>save data

Yes, its it's pretty much just a file can can download now that I think about it. I guess the only other way is to open and close Excel spreadsheets?

Afternoon, I am not sure this can be done but thought I'd ask just in case. I have a form Access Database I've built for multiple users. The tables are housed in separate database I've uploaded online. Can I use the form database to retrieve/add data to the database online? Thank you.

Button goes on database.

Access Database is the master. However, I have a query that only pulls certain records for a specific time frame from a table. I am not sure how to export the query to excel so that it goes to the next empty line each time? Thanks

Hi, I am hoping to get some code for a button click to transfer query results to an existing worksheet. So far I have the below code that opens the Excel Workbook and transfers the query to the worksheet. However, my problem is that it over rights the existing excel data previously added. Is...

I ended up using one table and doing a duplicate delete query. Works perfect. Thank you for the advise. Not sure if I need to click anything to mark as resolved so? Thanks again!

Thank you guys for all your replies. I am going to try adding a STATUS column and then remove the duplicate record using just the one table.

After filling in my table and field names with, DELETE FROM Table2 INNER JOIN Table1 ON Table1.FieldName=Table2.FieldName. I get an "Specify the table you containing the records you want to delete" error message.

I have a PickUp table (Table1) and Completed table (Table2). On button click a record from listbox_pickup gets: - added to the ReadyForPickUp table (Table3) - removed from the PickUp table (Table1) - added to the Completed table (Table2). However, there is an option on the form that houses...

Afternoon, I've been trying to figure this out for days. I feel like its simple but I just can't get it. I have two tables, lets say Table1 and Table2. I am trying to delete duplicate records in Table 2 that are already in Table1. My query, "query1" finds the duplicate records with joined...

What is the redesign?

Still not working, I can't even get the Label to become visible.

I've tried this and its still not recognizing the label on another form. Main form will always be open before button is clicked. alertBtn Form = EditProcessingUpdates updateAlertlbl Form = Main Private Sub alertBtn_Click() Dim I As Long, J As Long I = DCount("*","ProcessingUpdates Me.Requery...

Thank you Mark. I was hoping for some coding help.

Thank you so much for your reply. You def addressed an issue that was in the back of my head. Maybe you can help me with how and why I need the label, for another possible solution that may work better. I have a _be file "ProcessingUpdates" that allows anyone to add a record(update) to the...

Thank you so much for your reply. You def addressed an issue that was in the back of my head. Maybe you can help me with how and why I need the label, for another possible solution that may work better. I have a _be file "ProcessingUpdates" that allows anyone to add a record(update) to the...

Hi, I am hoping someone can help. Not sure it can be done. Can't find anything online, so hoping you guys might know. I have a form with an embedded report. This report populates data from the UpdateTable. I have a requery button on my report that allows me to refresh for any new updates...

Good Afternoon, I am wondering if someone can assist with a form with a Search box query. I know how to add a query for one key word with a pop up MsgBox but what Im looking for is a form with a textbox that allows the user to input a word or phrase. When the search button is clicked it will...