Recent content by plog

You've not given us enough information, please post all the VBA code. Is the VBA line above the one being highlighted when the error flags? Also, how did you get the SQL that you posted above? Did you Debug.Print your VBA? or are you just assuming that's the SQL that the VBA is creating?

You shouldn't do this as you have stated. And possibly not at all. What is this SKU for? Presumably you should have an autonumber primary key on that table and it should be the value you reference when you want to uniquely identify a record, not some concatenated frankenfield. Exactly how...

Only if you provide it--insert a column before/after the data and have a cell compute it (A1=1, A2=A1+1, A3=A2+1, etc.). Two methods come to mind: 1. Build a macro in excel to fix this. You take one of these files, build a macro that loops from the first cell in the Branch column until the...

Agree with tvan. You're focused on what to paint the third floor bathroom while the foundation of the house is a a few cinder blocks and a couple 2x4s held together with duct tape. Here's the big things I see with your tables: 1. Field names with suffixes. When you feel the need have a bunch...

Here's the part I wanted: So the goal is to export data to Excel. That can be done without a Rube Goldberg machine. You can get the data you need in a query without VBA or making tables or deleting data. You just need to build the correct query, once that query is correct you can export it...

Moving data is a huge red flag. Why are you doing this? What's the ultimate goal? Why can't data just live where it is and you use SELECT queries to obtain the necessary results? Further, none of that SQL is dynamic. It's literally 2 literal strings of SQL. Why not make 2 query objects to...

This can't be a coincidence: https://www.access-programmers.co.uk/forums/threads/hide-inactive-data-and-show-active-data-only.330677/ Is this homework? Do you work with victorlindh? Are you victorlindh? The fields/tables in the database in the thread I have linked above is 95% the same as...

When you need to group data together that's called an aggregate query. One of the functions available when you do that is AVG. Give this link a read: https://support.microsoft.com/en-us/office/sum-data-by-using-a-query-430a669b-e7fd-4c4b-b154-8c8dbbe41c8a Then try it on your data, if you...

Use the right datatype for your data. [On Hand] is a text field in your database, it should be a numeric field. Comparisons on text are different than comparisons on numbers. When you use > or < on text it does it character by character. That means: "10" < "3" because "1" is less than "3"...

When/how are new files obtained? Does some other system dump the .csv files into a directory every Tuesday at 7:53 pm? So that they are always there at 7:54 ready to be processed? Are you randomly emailed these .csv files by people who need prompting so they might all be there between Tuesday...

FriskSL also needs a sovereignty field

Case Else txtb = "recheck" I believe you either need a colon after Else or to put the actual assignment on a new line after Else Of course what you really need is some sort of saved data structure that stores records of associated data together. If only the developers of Access had thought to...

Nope. Inside a Mid() Left() will work in this case. But Left() really isn't needed because Mid() does everything it does and more.

Can you show your VB.net code? My gut is telling me its the single quotes around your criteria. Of course I'd expect a syntax error by the debugger though.

You would use an InStr() inside a Mid(): https://www.techonthenet.com/access/functions/string/instr.php https://www.techonthenet.com/access/functions/string/mid.php Mid extracts a substring from a string and InStr Identifies the spot in a string where a specific substring (or...