Search results

Hi, Hoping someone can help me out. Within my access database I have a linked table to a SQL Server. I have setup the ODBC connection and the table link works no problem, except is missing random columns. I've also tried other table from the SQL server and they are also missing columns. They...

Hi, I am intermittently getting a runtime error, "you cant assign a value to this object". I'll start with the section of code; Private Sub Form_Current() On Error GoTo Error_Form_Current_Click Dim initialNotify As Boolean Forms![frmAccountDisplay].Refresh If initialNotify = False Then...

Hi, I've created a combo box that when you click on the list it brings up 3 columns with a number field and then a first and last name field. Note that this data is stored in a different table. When selected/changed, i want the data to input in the current table fields accordingly... So...

Hi, I am receiving this error; "Invalid SQL syntax, cannot use multiple columns in a column level CHECK constraint." Without explaining my disaster of a situation anyone have any ideas?? haha Thanks.

Hi.... In my form I would like to create a command button, that when clicked on, will enter the date & time into another field. As well as the same for end time. I would like to automate this feature as much as possible to eliminate user manipulation when the database is completed...

Hi, I am in need of some serious help with my database. I have two tables created, lets say one is Name and the other is Company In a form for "Name" i am trying to create a feature that will allow me in a drop down box select a "Company" and also bring another two more fields from the...