Search results

You need a space before the highlighted text, or after the JOIN statement.

Well of course that doesn't work, your type defines 3 possible values ( projectName , projectNumber , projectDescription ) you tried to access [regionName] which is none of those. In short, you cannot dynamically access the type the way you are trying to do. You can still use a loop, but each...

mdlueck is correct, no way around the bloating beast that is Access. You could use the CreateDatabase command to create a temporary work database, import your data in there, append the final results into the backend, then delete the whole database upon completion.

http://www.everythingaccess.com/products-services.htm They have product that seems to do what you want which means it can be done. However I don't know if it can be done purely through VBA. This type of information is usually retrieved from the call stack which can be done be reading CPU...

I can't think of any way to "reliably" do this, since doing it this way is not at all advised. You are essentially trying to create two systems of record for the same data set, by all accounts this should not be done. If you want your users to move to Access then have Access be the system of...

As a contract programmer I would say you are not any under obligation to pay for the time spent on a bid, unless you've lead that programmer to believe they had the job already, if they are bidding for a project then it is like an interview, put your best foot forward and try to land the job...

Dim dkg As Variant, str As String set dkg = Application.FileDialog(1) dkg.show str = dkg.SelectedItems(1)

This may sound crazy, but how are you checking the file to see if the zeros are there or not, Excel? If the answer is yes than that may be your problem, try opening the CSV file in notepad or wordpad and see if the Zeros are there, Excel will try to be "helpful" by auto converting text to...

Simplest way would probably be the shell command Shell Chr(34) & "C:\Temp\MyTestForm.exe userNameHere" & Chr(34)

PUT is usually an FTP command, have you tried using POST?

The command line is where to go, I would modify your main method in the program.cs file to accept command line arguments. Then have a public property such as username on your form, set that in the main method before the Application.Run call is made.

Not so much a number of folder limitation, but the length of the path that limits you. IMO it depends on your design as to how many sub-folders make sense, if you have a year / month / day structure then it makes sense to have 30-31 sub-folders under most month folders...

based on the variable names I'm guessing that strDateComp is a string, in that case the line of code strDateComp = Null will fail because in VBA you cannot set a string equal to null, you can set it equal to Empty, or a zero length string "", but not null.

I don't think you gain much in this instance...however if you are going to compile this to an MDE I would leave it in there, MDE's or ACCDE's don't like unhandled exceptions so a little extra precaution is not a bad idea.

First, this is the VB.NET section so this should really be posted over in the VBA code area since that's what this code is. Second, I suspect the error is on this lookup function DLookup("[Password]", "tblUsers", "[UserName]='" & txtUserName.Value & "'") If the user/pwd combination isn't...

Sounds like someone setup the security incorrectly and overwrote their system.mdw file, this would require a re-install of Access to fix the issue.

I would do it a bit differently, rather than go through each record, I would build a dynamic SQL string and execute that, on large number of records there will be a major performance benefit. Function RemoveCrLf(strTable As String) Dim fld As DAO.Field, tbl As DAO.TableDef, db As...

this works for me Type foo sAR() As String End Type Function retArray() As String() Dim sAR() As String ReDim sAR(1 To 3) sAR(1) = "A" sAR(2) = "B" sAR(3) = "C" retArray = sAR End Function Sub test() Dim stringArray() As String Dim f As foo stringArray = retArray f.sAR = retArray...

I believe Access considers Forms class objects so the code behind them probably behaves like a class module does, the public variable is available within form1, but not outside...unless you declare a form1 object, then you could access or assign data to/from the public variable.

As someone who is in a similar situation I can say I have not found a reliable way to do this. Adding extensive logging to the process then checking the log file/table is one way to go. There isn't a rock solid method, and Access is prone to random hangups, I had an Access application running...