The database is already on a shared drive. The excel document is located on the shared drive as well, same directory as the database. Like I said, this all worked fine for the last 2 months, until Monday, then the error came up. Since the database is live, and updates are constantly made to it, it's important the users have the ability to refresh the file as necessary.
I've never had this issue before. Any change this might have...
jclover
Last Activity: Mar 11 '08, 10:43 PM
Joined: Jul 31 '07
Location:
-
ODBC Connection Error
I have an excel spreadsheet that is linked to a query in an access database on a shared network drive. There is no security in the database, or the spreadsheet. As of this weekend, the other users of this query are no longer able to refresh the data from the Excel side (via existing macro, or simple refresh) without getting:
"[Microsoft][ODBC Microsoft Access Driver] Type mismatch in expression"
However,... -
Instr Command and the Quote
I need to pull the characters that are left of a specific character in an Access Query. Here's the code I currently have.
Left([Desc],InStr([Desc],""))
The problem is, the value that I'm looking for in the string is a quote ( " ). How do I do that. -
Form Control - Query, then adjust
This might be a freshman question, but is there a way to have a field in a form be populated by a query, and then be adjusted by the user?
I want to have a sub-form that populates data automatically based on matching criteria in the form, but gives the user the option of "overwritin g". One they close the form, any changes are written as a new record to a specified table (that part I can do). -
Thank you for your help. I didn't know last takes sorting order into account.Leave a comment:
-
General "Last of" vs "Max of" question
When creating a query in Access (assumption is the data has a unique ID which is numerical...new records, autonumber) how reliable is the "Last of" grouping function vs the "Max of" the ID, and then linking that max of with a record in another query. I've had issues in the past where the "last" record, isn't necessarily the last record entered.
In my case, I'm updating product pricing, so I always want... -
I figured out the problem. It was due to the relationship between the tables, with the main table linking to the other table with "one-to-many/Enforce Referential Integrity". I redefined the tables, as a one to one, no enforcing, and it solved it. Everything else runsfine still, but I don't enderstand the root of the problem, only that I fixed it.
Anyone want to take a quick minute to teach me what I did?Leave a comment:
-
Sometimes it SQL Inserts, Sometimes it doesn't
Short version.
I have form that opens a linked form where data is populated automatically based on queries, and some data is entered. When this form closed I have SQL code that writes the various fields into the database, and then closes the form. The original for then recalcs so that the entered data now populated. Works grand...sometim es. Sometimes when you close the form, the data just doesn't write into the database due to... -
Frustrating. This was working a couple of weeks back, but when I revisit the database now, it's saying that it's "not a valid bookmark".
...Code:'Close the form I just entered the data into DoCmd.Close acForm, "frmMPR_Price_Subform" Dim varBookmark As Variant 'Store the original Bookmark of the sheet I want to requery to show the updated form varBookmark = Forms!frmMPR.Bookmark
Leave a comment:
-
Seems to solve my problem. Thank you.Leave a comment:
-
Refreshing a Form Without Going to Record One
I have a form with a subform, and a child linked form.
The main form is a data entry point for different business tracking. The child form that is opened from that is used to enter product information, that when closed, refreshes the main form, so that the product information appears in the subform area. (Basically populating a list)
Right now on the "close/update" button of the child form, I have code... -
I think I got it with this:
...Code:Dim rs As Object Set rs = Me.Recordset.Clone Dim ChannelAdj As String Dim Channel As String Channel = Forms!frmSpecialPricing![Retailer] If InStr(1, Channel, "'", vbTextCompare) > 0 Then ChannelAdj = Replace(Channel, "'", "''", , , vbTextCompare) Else: ChannelAdj = Channel End IfLeave a comment:
-
I take that back. It executes the code...no errors, but now the find function no longer works. It won't filter for any criteria.Leave a comment:
-
Seems to work. Thank you.Leave a comment:
-
Now it's runtime error '2186'. Any thoughts?Leave a comment:
-
Run Error 3077 - The Apostrophe problem
I'm using multiple criteria to pull up records in a form. However, whenever the "Retailer" field has a text string with an apostophe in it (example: Fred's Electronics), it errors out "3077". I'm assuming it reads the ' and it cuts the field short. Is there any way to define the value, or write the code to handle this?
...Code:rs.FindFirst "[SKU] = '" & Me![SKU] & "' AND [CHANNEL] = '" &
-
Error Null Type Conversion
I'm using Microsoft Access to try to put together a form that enters data into a table when the form is closed, not a typical live form. Several fields are combo lists that pull from various queries. When I execute the code, I keep getting this error:
1 field(s) set to Null due to type conversion.
Here's the code:
...Code:Dim strSQL As String Dim Eff_Date As Long Eff_Date = Me.Eff_Date
No activity results to display
Leave a comment: