Search results for query: *

Many thanks for the guidance. It is working just as I'd hoped now. Thank you again!

Ok, let me see if I can describe my problem a different way. I am importing a text document that contains hard drive information for multiple servers. The text document imports the exact same way for each server, (all data into one column and each line of the document is one row). I want to...

That seem to be more or less what I am looking for, although I don't know the way to read in the current record into a string. Example: (Once the recordset has been opened, there should only be one record in that record set {at least for the case that I am using it for}) Dim tmpStr AS String...

I am looking for some guidance. I wrote a SQL statement that returns only one result every time for a table. I need to get the data from that result into a string so I can modify it before I put it into another table. What should my next step be or should I use a recordset? CODE: <code>...

Is there a way I can programmatically check for an object? My dilemma is, I want to see if a table exists before I give the command to delete it. If I DoCmd.DeleteObject and the table isn't there then I get an error. Thanks for the help.

djayam.... Perfect! Exactly what I was looking for! Thanks a bunch.

I'm sorry if someone has already answered this question, but it's starting to get late and my brain is fried from searching. I am looking for some guidance no how to pass VBA code into either a pre-existing query or create a new query for that instance. I have toyed with the ADODB.Recordset a...

I was wondering if there was a way to get a number of results in a query. I am running a query by form and I want to know when it returns 0, or for that matter any number of results. Just wanted to know if there was a easy way to request this. Thanks in advance.

The value is fine. I am trying to get my form to return a name opposed to a number. When the function returns a name it, for some odd reason, is the name of the next row on the table.

Is there something wrong with my code? I keep getting the wrong value on this function. I get the value that comes next on my list. =DLookUp("DepartmentName","tbl(dropdown)Departments","DepartmentNumber =" & "'" & [DepartmentNumber] & "'") I also tried...

Put this in the Control Source and it displayed "error": =DLookUp("Hardware","tblBudget",[Department]) Put this in the Control Source and it only displayed the first row's value: =DLookUp("Hardware","tblBudget",[qurBudgetUnbound]![Department] )

Once requested wouldn't in remain the same? how would I get it to change for each department? This is in the ON OPEN event: Me.txtBudgeted = DLookup("Hardware", "tblBudget", [qurBudgetUnbound]![Department]) BTW....this code doesn't work.

apologies.....I believe that it will work for my purposes.

The dlookup function will only return the value that you request, unless I am mistaken.

Here is the situation.... I have a report that gets data from a query from one table. In the report it displays: Date, Item Description, Department Name and Price. The report is divided by department and in the footer I have the Price totaled for each. In another table I have the projected...

Thanks!

I thought of the Dlookup method, but that will only return the value that you tell it to search, right?

...Helpful........ Would you care to share it with me?

Is there a way to get the value of a cell on a specific row by looking up or querying another value on the same row? Example: Barcode is a field/column; Serial Number is a field/column. ::::You enter or scan the barcode and the value from the Serial Number field appears in an unbound txtbox.

The default value set by Access was 0, because the type was set to Currency. But even then when I actually use 0 instead of "$0.00" the IF statement should work right? Have I done something wrong in the statement? Remou.... Really? I typed the same thing in my immediate window and it came back...