Search results

I don't think this is a problem caused by the program itself because it works fine when the tables are linked to the old back-end .mdb file, but as soon as I relink the tables to SQL, it stops working. Basically when you finish typing in info in a txtfield and based on other 2 values on the...

I have just finished creating an ODBC with SQL Native Client (10.0), relinked the tables using this new driver and it still doesn't work. Thanks

In ACCESS 2007, when I created the ODBC, it just said SQL Server in the "Create New Data Source" window. How would I know if that's the right driver? Thanks

Hello, I have just finished importing an ACCESS db (back-end) to a SQL Server 2008 db. My front-end is ACCESS and the back-end is SQL Server. When I would fill in some txt fields on a formA, another formB is supposed to open. This used to work when the tables were linked to my old ACCESS db...

Hello, after I compact and repair my database, a copy of a specific table (that's already on the diagram) pops up on the relationship diagram with the same relationship as the original table. This is causing the program not to work properly. Can someone give me a hint on this? Thank you very...

Yes, it is set to "Yes". Thanks

Hello, I added some text fields to a report. These have the control source linked to a table, and some are blank and some are not. Now the problem is that when I "Print preview" the report, it shows the blank spaces from the blank fields. Is there a way to fix this so the blank spaces don't...

Hello, If I have a table with duplicate fields (studentID): studentID Year a 2005 a 2006 a 2006 b 2006 b 2007 b 2007 Is there query that would give me...

I am using ACCESS 2003

sorry, the PC I have to work on has ACCESS 2003, so this is what I am currently using

I am using ACCESS 2007 Thanks again

I assume you are talking about the "Order By" property of the report, right? If so, I tried that too and it still doesn't work. Thanks.

Hi everyone, I have a report and its record source is a query that supposedly orders the records by 2 fields (filedA and then by fieldB). When I open the datasheet view for that query, it shows me the correct and expected order, but the report shows the records in a different order. Can...

Hello, I have the following stmt in VBA: DoCmd.RunSQL "INSERT INTO tStudentYear(studentID,Year,schoolID) VALUES('" & theStudentID & "','2009','" & theSchoolID & "')" being: theStudentID and theSchoolID both Strings. It doesn't insert the records in the "tStudentYear" table, and I already...

I added the 3rd argument to the iif function, and have tried deleting the red quotes and have tried different combinations and is still not working. Any other ideas? Thanks

Hello, I have the following on the control source of a text field: =IIf([pcSSISSA]=True,DLookUp("[Reason]","[MissingFormReasons]","[ID]"="[pcSSISSAtext]")) being: [pcSSISSAtext] an integer [ID] an integer it is giving me an error, what would be the right syntax? Thank you

Hello, I have a front end which is in ACCESS 2003 and want to link it to the back end which is a SQL Server 2005 db residing on a different machine. How would I do this? This is the first time I am doing this process, so I really need help on this. Thank you very much.

Hello, I have a general question. My users lately have been getting this "Recordset locking" message from Access. We have between 8 to 10 users using the same DB concurrently (the back-end is on a server, and the front-end is locally on their PC). I know that when certain amount of users...

It is now doing what I was looking for. Thank you very much

Actually theID is a string of 10 characters, would the syntax change? Thanks again