Recent content by dalmatian

I experimented a bit and I found a solution for VBA code from first post. To repeat, in Access (without SQL BE) VBA code to filter the child forms that starts from the master form is: Private Sub OpenLocalUsers_Click() Dim sWHERE As String sWHERE = "[Computer]= '" & Me.Computer & "'"...

Starts over again. In access database (without SQL Server as BE), I was erased all relationships between tables, and also in each table properties under 'subdatasheet name' field I chose [None]. Also, I deleted all queries and compact and repair database. After that, I started sql server...

Thanks for replay, but I still get a same message: Run-time error '102': Incorrect syntax near ';'. and debug pointed me at same line: DoCmd.OpenForm "FLocalUsers", acFormDS, , sWHERE

After upsizing access database to sql server I found a few problems. My configuration is: Win xp, access 2010 (but I still using 2003 format mdb). SQL Server is Express 2008 R2 located on win server 2003 x64. Connection is established through ODBC. Upsizing tool didn't report any mistakes. The...

I tried various combinations and by accident I found one that works. Me.subEmployeesHole.Form.Search_Surname.RowSource = " SELECT Company.Name_Surname, Company.Department FROM Company WHERE (((Company.Department)=""Department1"")) ORDER BY Company.Name_Surname;" This expression is exactly what...

Again, I compressed and uploaded. I also work with WinXP. I replaced previous file with new one.

Thanks for replay. No success. I added the example of my database (rather impoverished). I left only two separate departments (subforms), and third (subform) which covered all departments. Database is in 2000-2003 file format. I work with access 2010, but still uses the old file format.

I tried, but without success. All the time I receiving different error messages, and finally I received a message "Run-time error '424' Object required" and point me at: .RowSource = .RowSource & " WHERE Department = '" & txtSearchBox & "'" I'm not really familiar with VBA. All code what I...

Thanks for replay. When I started to work on my database, I mainly used tables only (like advanced spreadsheet), and after few years I finally decide to start using queries and forms. I created query from three tables, and based on that query created one form with 30 or more textboxes, 3...

Hi This is my first post on english language, so if i made some mistakes, sorry. I have a main form with few command buttons and subform-hole. Each command button open in subform-hole acctualy same subform with different filter. For filtering subforms I used code: Private Sub...