Search results

Thank you, but a few questions- How do I store the query? How do I tell access which place on the form to put the data? Can I use the existing form I have which displays all of those fields?

I have a wonderful piece of SQL which does exactly what I want it to: Dim sqlstr As String sqlstr = "SELECT * FROM FromLegal LEFT JOIN FromCDG ON [FromLegal].[IDNumber]= [FromCDG].[IDNumber]" & _ " WHERE FromLegal.CounterpartyName Like """ & "*" & Me.CPNAME & "*" & """;" DoCmd.RunSQL...

I have a wonderful piece of SQL which does exactly what I want it to: Dim sqlstr As String sqlstr = "SELECT * FROM FromLegal LEFT JOIN FromCDG ON [FromLegal].[IDNumber]= [FromCDG].[IDNumber]" & _ " WHERE FromLegal.CounterpartyName Like """ & "*" & Me.CPNAME & "*" & """;" DoCmd.RunSQL...

Wildcard Syntax So I have the following code in my query: FIELD: Expr1: [CounterpartyName]=[Forms]![test]![CPNAME] Or [Forms]![test]![CPNAME] Is Null CRITERIA: True unfortunately this only returns a record when the name is typed exactly. How can I use a wild card to return records when...

Could someone explain where to implement this SQL (full explaination would be great since I am pretty clueless on this). Click the link. http://www.access-programmers.co.uk/forums/showthread.php?t=70751 thanks all

I need to look up records based on a number of fields. I want to do this with a query. So I want the user to be able to enter text into a text box on a form and then use that as the criteria in my SQL string. I do not know how to put the user input into the string. Thoughts, or is there a...

i had no idea, i though if you put "as data type" at the end that meant that they were all that data type. But anyway, any ideas about my new record problem? I am freakin' out over here

Don't understand your question, sort of a self taught programmer and a newbie in access. If you mean as opposed to using an array or some more efficient data structure, its because I have to hand this off in a few hours and I don't have time to mess with that. Any help on the new record thing...

I have a database that will need to be updated from an excel spreadsheet daily. However, the sheet only has part of the data that will be entered in a given record, i.e. some fields will be blank. So i have this function opening the spreadsheet and reading the data form the spreadsheet and...

All of the code below works except for the "DoCmd.GoToRecord , , acNewRec" line. I get an error message saying I can't use GoToRecore in design view. However, I didn't think i was in design view. I need a solution, anyone will do. I just need to create a new record so the data from the...

I went to reference, and included the Excel 8.0 Object Library, there was no 9.0. It still does not seem to work. The librarys I am currently including are Visual Basic for Apps MS Access 8.0 Obj Lib MS DAO 3.51 Obj Lib MS Excel 8.0 Obj Lib

Sorry... Reference checked? Not exactly sure what you mean. And which access library did you mean? Also, I am working on the ancient Access 97, which I think may have something to do with it. Let me know if you have any further ideas. Thank you

The code is below, it bombs out when I call "CreateNwRec (wb)" saying something about object does not support property or method. Function Opnxcel() On Error GoTo Err_Opnxcel_Click Dim oApp As Object Dim wb As Object Set oApp = CreateObject("Excel.Application") oApp.Visible = True Set wb =...

Urgent, Deliverable on friday If anyone can offer some help on this right away that would be great. I have to have this whole DB done by friday. Thanks

Function Calling I have a form w/ command button. The button opens excel and then reads data from excel and inputs it into a new record. In my call the the get/set record function it stops working. I think this has to do with passing the variable "wb" of object type. I need to pass wb...

did you need to grab the whole spreadsheet or just a range of cells? I'm working on something similar right now