Search results

so im trying really hard to understand relationships and kinda tough from the outside in. Ive stop coding this program to concentrate on learning how to query with relationships and see how they interact etc., but i dont know where to start. if i can see it working then i will understand it...

I cant figure this out. im trying to use a variable as my field name lookup in a dlookup statment. if i change the variable to this it works fine price = "[1 x 1]" Dim pipesize As String Dim price As String If Me.PipeSizeTxt.Value = 0.5 Then pipesize = "1/2"...

I have this code here which will get me the table names that are local.. Dim strSQL As String Dim lst As ListBox Set lst = Me![YearsList] strSQL = "SELECT [Name] FROM MsysObjects " & _ "WHERE (([Type] = 1) AND ([Name] Not Like '~*') AND ([Name] Not Like 'MSys*') AND...

This is going to be a little more trivial than the title makes it out to be, but im hoping someone can help.. What i need to to do in essence is this...Look through all tables that have a name beginning with "441-" and if a criteria matches a field in there delete that table, then look through...

I've seen a couple post on this issue but none that solved my issue. I have update statements that run flawlessy but do not actually update...any help would be appreciated in trying to pin point this out. I have stepped through the code and all variables are being pulled correctly just...

Hey guys and gals, I have a script here (partly ripped from others) where i download a file from the internet, it saves it on my desktop. It then opens the file transports data to it and moves it to another directory. All this works fine when the downloaded file is saved as a single name...