Haha, I completely agree (and thank you for the honesty). Eventually this process will be changed to have each store have its own unique number, which will solve this nasty problem. Unfortunately, as this is a new role I am in and there is an extremely time sensitive nature to getting this information together, I do not have the time I would like to fix the root cause of the problem.
I did manage to put a quick fix in by adding a zip...
Lynch225
Last Activity: May 9 '14, 03:12 PM
Joined: Jan 9 '12
Location:
-
Last edited by zmbd; Apr 24 '14, 01:50 PM. Reason: [z{placed code tags - please see faq}{sorry had to shift the tag}] -
Joining Like Fields in Access Query
Hello All,
I have 2 tables from 2 different data sources, where unfortunately the only fields able to be joined are street address, city, and state. Of those fields, obviously street address would work best. Unfortunately, since the 2 tables are from different data sources, one of which is from manual entry of POs, the street address will only join correctly about 50% of the time.
Ex.
Table1
Address... -
Thanks again dsatino...
You were definitely right about pointing the cursor at a previous record for it to update- worked like a charm last night. Of course, when I ran this morning there was only 1 record that showed up haha. I just made a temporary change by changing the Allow Additions property to yes so hitting enter will move to a new record and update the table accordingly.
Much appreciated!Leave a comment:
-
Thank you for the responses...
The record is not updating in the bound table, so it's not an issue with the update query.
As far as the reasoning behind not having the form bound to the larger table is that:
1.) I run an unmatched query, which basically shows which records are invalid for a single field. One table imports data from our labor management (non-Access) database. Employees choose certain labor codes to...Leave a comment:
-
Thanks for the response dsatino...
I should have clarified. I have a form bound to a table, as you suggested. As I update the form, the resulting fields in the table will also update. This works for all records except for the last record for some reason. I then take this table and run an update query to update these specific records into a larger table. I guess I did not need to specify this...
So if the form is bound...Leave a comment:
-
Last record of Access form not updating in table
Hello all,
I have an issue with a form updating all records in a table except for the very last record for some reason.
A little background, I have an unmatched query that appends results to a table so that the records are updateable. I have a form that is based on this table, where the user updates the invalid fields on a form, and then an update query is ran to update the records in the master table. All of this works great,... -
Hi Rabbit, thanks for the reply.. I should have mentioned that it was Excel VBA, which when looking at the site should be in a different forum. My apologies.
The good news is that after doing some more research, I found out that Excel Solver is a difficult thing to automate. Apparently Excel solver does not like to use Ranges per se in setting parameters, only $A$1 style (whatever the coding term is for that) :)
I found...Leave a comment:
-
"Object Required" error during Excel Solver Loop
Hey all,
First, thanks for taking the time to look at this thread. I have a written a loop that utilizes Excel Solver to calculated the best option for multiple columns. Here is my code so far:
...Code:Sub Solver2() Dim x As Integer Dim A, B, C, D, E, F, G, H, I, J, K, L, M, N, O, P, Q As Range Sheets("Matrix").Activate Set A = Range("C377") -
Wow, something as simple as a period. Worked perfectly, thanks!Leave a comment:
-
Opening Excel file from Access VBA not working
Hey all,
I am having issues when trying to open an Excel file from Access VBA. Here's the code I have so far:
...Code:Public Sub Prod() Dim xlApp As Object Dim xlWorkbook As Object Dim strProd As String 'Prepare Staff list Set dbs = CurrentDb() DoCmd.SetWarnings False strProd = "C:\Docs\Hours.xlsm" Set objrst = dbs.OpenRecordset("Report Date") -
Ahh yes, of course I was being brain dead. Just changed strStaff in the line to objrst and worked like a charm. Thanks!
Now I will have to revisit the early chapters in my Access 2007 VBA manual...Leave a comment:
-
Type mismatch on CopyFromRecordset Access
Hey everyone, I am having an issue when exporting a table from Access to Excel. I do not know why I keep getting an error, as I have used this code before. I'm assuming it's an easy fix and I'm just brain dead at this point of the day. Here's the code:
...Code:Private Sub Staffing_Click() Dim dbs As DAO.Database Dim objrst As DAO.Recordset Dim strXLStaffing As String Dim strStaff As String Dim xlApp As Object
Last edited by NeoPa; Jan 19 '13, 09:52 PM. Reason: Tidied for easier reading (Removed some blank lines) and added code line reference. -
Well after scouring the internet and posting a new topic, I got a response that was very simple. All I had to do was add quotation marks to the sqlStr and sqlPl lines as follows:
...Code:If i > 0 Then For j = 1 To UBound(Narr) - 1 RecsChose = RecsChose & "Trailers_Unloading_LA.Door=" & "'" & Narr(j) & "'" & " OR " Next RecsChose =Leave a comment:
-
Ahhh yes, something so simple. Thanks rabbit.Leave a comment:
-
DoCmd Open form error on filter
Hey all, everytime I open the form Clickform with a button, I keep getting a runtime error 3464- data type mismatch in criteria expression with the DoCmd line highlighted.
Basically I have a group of checkboxes (Check1, Check2, etc.) on a form called Check, and the code filters through the checkboxes to see which ones are checked. Once the user clicks the button (called Command0), it opens up the Clickform and applies a filter based... -
Hey C CSR, still nothing to report. Its been a crazy weekend, but I'll be doing more work on it tomorrow morning if I can find out anything else. I'll be trying some different things to see why it's not working and I'll repost. ThanksLeave a comment:
-
FYI, when I did create the new query "CheckQuery " I was discussing that has the exact same properties as "Trailers_Unloa ding_LA" and a new form "Checkform" based on that query, I got the sql code:
...Code:SELECT Trailers_Unloading_LA.Door, Trailers_Unloading_LA.Trailer_Number, Trailers_Unloading_LA.LA01, Trailers_Unloading_LA.LA02, Trailers_Unloading_LA.LA03, Trailers_Unloading_LA.LA04, Trailers_Unloading_LA.LA05,
Leave a comment:
-
Hey C CSR, I am still having the same issue. I should have mentioned that the form "UnloadNow" is based on the query called "Trailers_Unloa ding_LA" and not a table by the same name. I was looking into the sql code yesterday when I was experimenting with how the code should look. When I added the criteria 9 OR 10 OR 11 into design view of the query "Trailers_Unloa ding_LA" and opened in sql view, I got the following:...Leave a comment:
-
Well I got the form to open without an error message (finally) by messing around with the filter part of the open form command. While looking at different references, I didn't see any that included the SELECT portion of the sql statement. I removed some of the code so lines 18-27 of your first code now look like:
...Code:If i > 0 Then For j = 1 To UBound(Narr) - 1 RecsChose = RecsChose & "Door=" &Leave a comment:
-
The form UnloadNow is a split form based on the query Trailers_Unload ing_LA. If the sql portion of the code, would I have to reference the original tables? Or is that not the issue?
Again forgive my ignorance and sorry for wasting all of your time earlier when you were right with the first codeLeave a comment:
No activity results to display
Leave a comment: