Search results

Actually I might have fibbed a on that one. In your append query. Put the following (with your modifications) in the criteria of the SerialNumber field: Not In(Select SerialNumber from tblAppendingTo)

No need to post in multiple forums. I would start with this: http://developer.ebay.com/windows/

Use the "Find Unmatched Query Wizard" and create a simple select query. That will show you how to only select the records that are not already in your Master table. You can then use that knowledge to enter your criteria for appending the new data.

You could create two queries. One that appends records if the serial doesn't exist in the master. Another that updates if the serial exists. I know this is almost the same thing that you said above. :) Another option would be to do as Pat said below and create a master table with ALL the...

SELECT Table1.Students FROM Table1 UNION SELECT Table2.Students FROM Table2 UNION Select Table3.Students FROM Table3 If you want to show duplicates change the UNION to UNION ALL

So if a certain condition is met then you want the textbox click event to do something?

The reason that you are getting the error is because in this section: Do Until rs.EOF 'begin the loop If rs!Min < curXnickel < rs!max Then curYnickel = rs!nickelprice rs.Close Else rs.MoveNext End If Loop If your 'If' statement is true you are...

Gotcha, thanks for the clarification. =IIf(IsNull([Seniority]) Or [Seniority]="",'X','-') Try that. Could be that they are empty fields rather than Null fields.

=IIf(IsNull([Seniority]),'X',[Seniority]) Change it to read as above. the iif statement works like this: IIf([condition], if condition is true do this, otherwise do this) In your case if there was data it was putting in a '-' which is what you told it to do.

If your Emp_ID is a numeric datatype (number, decimal, integer, etc...) you will get that error. Don't put the apostrophes around it and things should be fine.

I can run Update Queries on linked Access tables and SQL tables where I have the proper permissions.

Also if you use an ASP.NET, ASP, PHP, etc... solution you will need a webserver. I have never used DAP so not sure if a webserver is needed for that. I know schools usually have tight budgets, so something else to think of.

The cbo prefix to make your code easier to read and understand. If you have an object called Cause, you might know what it is since you developed it, but what happens if you don't support it in the future or someone else takes over the project and has to implement some enhancements. Now that...

The SQL in the bolded line about should not be in quotes.

One option would be to have a report form. On the form you have a drop down and a button. Dropdown list would contain the names you want the user to see, and the parameter (hidden from user). When they click on the button it loads the report and passes the parameter to it.

Either the path will be hardcoded in your application, or you will need to go to every PC that is using this and create the DSN entry. Also anytime the database you are linking to's location moves you will have to change the DSN entry on each PC vs. making only the change in your application...

This is what I would do.

Do you mean that you have a DSN connection that you want to use, rather than your current method? If so then "DSN=myDsn;Uid=username;Pwd=;" should work. A good site for connection strings is http://www.connectionstrings.com

The forum greaseman is talking about is www.vbforums.com If asked, they might be willing to share the [RESOLVED] code.

I 'think' you can go to Tools | Options. Look on the Tables/Queries tab and choose Owners for the Run Permissions. (Access2k)