Search results

In my view on the SQL Server the datatype for the missing columns is blank... I think i figured out the problem, it boils down to a permission issue. Ive since learned that the data type on the SQL Server is a user defined datatype that i currently do not have access too. All the fields that are...

Hi Pat, Thanks for responding. When I look at the missing columns in SSMS, they all appear to not have a set data type, but a system type of varchar

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...

Sorry for the late reply. Thanks so much everyone for your help.

First thank you for being patient and trying to help me out..My apologies for all of recent replies :) Also apologies for this only dawning on me now; The chkFileInUse checkbox is not the only control/field that is being impacted. Once the error occurs, the form loads displays all the correct...

I've added in the statement for allowedits = true at the begining of the code for the form load event. - no change also updated the executing query to remove "distinct row" - same error. error occurring now 85% of the time. :banghead::banghead::banghead::banghead:

The form is defaulted for allowedits = true i only set it to false if someone else is accessing the record. Should i be declaring it in code first in the form load event? I'm using an inner join with 4 tables in query for loading the form;?

Right now, without making your original change (unbound,update sql ..) I have open and closed the form 30+ times all different records no error. In 15 minutes from now, I can try to access the form and say 20 out of 30 wont load. I dont believe that its this particular control that its...

I have the record scroll turned off, the form loads based off what the user selects from their worklist. (another form) This form (Account Display) is based off a query, using a Select Distinct... query in the record source. (not sure if that helps you or not) Its not all records, only some...

I've tried with and without the .value. I removed it and am still getting the error intermittently. the checkbox default is set to false

For the moment it appears to be working, haven't been able to make the error occur. Loaded about 30 accounts and no error. However i was also able to do that this morning, and then it crashed. Should I have the section of code loading on a different event? Should I put in a wait command...

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...

Worked like a charm...Thanks soooooooo much!

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...

What do you do if you have say more then 20 check boxes.....say 50? The Query builder does not allow that many fields

Thanks Doc Man, that is exactly what i am trying to do, how do i do that on the Form?

I'm trying to enter a validation rule in a field. Where it looks up the dollar amount in one field and if it is less then the dollar amount in another field then enter an error message. I know the expression that i want to use, or at least i think i do :). I believe the problem is, that the...

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.

You Guys Rock!!..Thank you.!!!!!!

Timestart is the name of the textbox field that i want the command button to populate the time in. Thanks Jen