Search results

I have recently installed access 2007 and I get an error when trying to do an import data macro for an excel file. It says "could not find installable isam". I have googled and googled, and tried the following: renaming the msexcl35.dll and msexcl40.dll files, reinstalling access, verifying...

It was the autoexpand...I had it set to no. I changed it to yes and it works great. Thanks guys!

Here is the sql now: Me.Field40.RowSource = "SELECT [Part #], [Mfg Name], UM, Source, VendorID, ID FROM INVENTORYMASTERcombobox WHERE [Part #] Like """ & Me.Field40.Text & "*""" Still nothing. Column count is 6 I probably won't do the select a letter option as people will be copying and...

This is a branch off of that link...I couldn't get it to work so I am starting from one point and going forward till I get the entire code to work. That said, i added the .text so it looks like this: Me.Field40.RowSource = "SELECT [Part #], [Mfg Name], UM, Source, VendorID, ID FROM...

We have a combo box which currently pulls every record in our table, well over 70,000 records. This obviously isn't very good. I am trying to make the combobox results based upon the first letter they type in. Here is what I currently have: for the OnChange event, I have this...

ya, that code will probably solve my problem...I was just hoping I could get by without having to implement it :) I should be able to grind my way through it and get it to work...thanks!

I am moving the data from an access table over to an sql table this weekend...is the limitation on the comob box itself or is it an access table limitation? I'm hoping it is an access table limitation and moving it will fix the problem.

I have a drop down that displays all of our inventory master data using access 97...when the query is run that houses the data, it displays 66794 records. When I go to the drop down, it stops displaying at the 65536 record...it appears there are a bunch of white spaces after that. Anyone know...

I figured it out...WHERE (LEN([Part #]) < 8) Thanks!

I have the following sql statement: SELECT [PhoenixInventory-FTP-1].[Mfg Name] AS Mfg, [PhoenixInventory-FTP-1].VendorID, [PhoenixInventory-FTP-1].[Part #] AS [Part#], [PhoenixInventory-FTP-1].ID AS PartID, [PhoenixInventory-FTP-1].OH AS OnHand, [PhoenixInventory-FTP-1].OO AS FacOnOrder...

Changing it to Variant type fixed the problem. Thanks guys!

Still brings up overflow.

I have the following code, which when the button is pressed, a website is supposed to open with the quote number placed in the link itself. I need to pull the quote number from either the form or the query which is used to display data from the form. Anyways, here is my code: [code] Dim...

I got it to work by chaning my sql statement to be the same as what the form uses to pull data...so, if there is no data, then it doesn't do the dlookup, which is exactly what I wanted. Thanks for all your help, I just didn't think it through exactly correctly!

I have an idea...i'll do the rs.eof on the query that the form is drawn from. I'll get back to you in a bit to see if that works.

It appears I got everything to work so far; however, I now get an error: You entered an expression that has no value. This is on the line of code: Part = Forms!PreRequisitionBuysMasterForm1!Part There is definatly not a value on the form and this is sort of the problem I was trying to avoid...

Set rsTemp = dbTemp.OpenRecordset = ("SELECT * FROM InventoryMaster1 WHERE ([Part #]='0-7260-010-BL');") That brings up the following error: Argument not optional with .Openrecordset being highlited.

When I try putting in a specific part which should bring up results, I get a type mismatch error referring to the entire sql statement...here is the statement: Set rsTemp = "SELECT * FROM InventoryMaster1 WHERE ([Part #]='0-7260-010-BL');"

Since # is a reserved word, that is why I have placed [] around it...I am unable to change the name of the field as there are hundreds of applications already using that field with part # as being the field. It is a string, so the ' ' are necessary.

I saw the changed I didn't make, and I corrected them. Here is my updated code: Dim PurchSpecialHandling As String Dim dbTemp As DAO.Database Dim rsTemp As DAO.Recordset Dim Part As String Set dbTemp = CurrentDb Part = Forms!PreRequisitionBuysMasterForm1!Part...