Search results

Ah. I got ya. Really no way around it. Whoeve is using it will need access to it. Why don' t you set up a group of users for that database. It's what I do also.

Try using ODBC and create a DSN for the database. It's what I use when I code the frontend in C++

OMG is this person for real? LOL.......Ah crap I just pissed myself.:D

madmaxx2k3@yahoo.ca

rs.Fields("Check14") = CheckBox.Value is Check14 the field name in the database or the name of a check box. It mus be the field name in the table.

Should have brackets at the end of your set statement. Set db = CurrentDB() Like that

heh. Sorry for misleading you with the ;. I was programming in C++ when I posted it.

In the OnClick of the check box use: Dim db As Database Dim rs as RecordSet Dim rCount as Integer Dim cnt as Integer rCount = 0 Set db = CurrentDB(); Set rs = db.OpenRecordSet("Table") rs.MoveLast rCount = rs.RecordCount rs.MoveFirst Do Until rs.EOF rs.Fields("Checkboxfield") =...

That's why I used the OnChange event. I want it to keep adding to the text box.

Thanks Rich but I got it working with the OnChange event.

Hey all, Got a little problem. I have a combo box which has a list of values from a table. When a user selects a value it gets added to a text box. Now the problem I am having is when the user first opens the form and selects a value it doesn't get added to the text box. But if they select...

That's the one. Thanks

Anyone have the link for the ActiveX controls demo database from Microsoft. I can't find it anywhere. Thanks.

If you have the cash get Developer Edition. Doesn't really matter to me. The company I work for is pretty current with software so there is allways the "latest and greatest" here.

True. Never thought about the Developer edition. But still it would make sense to code a end user app in VB or C++. The job market demands more C++ or VB programmers than VBA programmers I find

Because it's not really mainstream. Sure it's good for little internal applications but for distribution purposes your better off to develop the application in VB or C++ and use Access as a backend database. It also saves the customer from having to purchase access to run your app.

I use a UNC in on of my database apps. I used: Public Const Images_Path As String = "\\mts004\common\databases\Mold_Repair\Photos\" and placed in a module. Works for me.

Why would you? It's best to let the user know that it is printing the report rather then making them guess.

Tell them to piss off and deal with it.:D Just kidding. Not to sure why that is happening. Never played much with user groups. I just make my own logon screens.

Not bad site design. On DataAccess.php you might want to check your punctuation:D