I found no easy solution to fix the issue with the memo field and the 3188 locked error. I used to open up my modal popup form off the main form to edit the record. I would pull the table record fields from the main form to fill in my popup modal form.
Private Sub Form_Open(Cancel As...
I looked around the web to find more information on error 3188 and found this thread...
http://www.dbforums.com/microsoft-access/1606228-runtime-error-3188-while-updating-memo-field.html
I found an interesting post in that thread about this problem. The poster indicated that the record is...
Anyone else have this issue with the memo field not updated past 2k characters using a RecordSet to save the table?
I never had to have a memo field past the 2k limit so this is the first time I've seen this issue.
PS: Should this thread be moved to VBA and Modules section?
Hello,
I have a form that allows me to add or edit data to a table. In that table I have a Memo field called 'fld_Tech_Intr'.
When I first create the record I'm able to add 2,000 plus characters to that memo field 'fld_Tech_Instr'.
When I try to update that field by using a RecordSet I...
When I update a database object's 'User and Group Permissions' does it matter what database location I make those from? In my situation I've been making the changes from my local PC front-end database. Will those changes follow through to the my co-workers local PC front-end database? (For...
I recently created a new database and new workgroup file in Access 2003. I took all my old tables, queues, forms, etc from my old Access 2003 and merged into this new database for a fresh start. I went through all my DB objects and assigned permissions for them using the 'User and Group...
I have a form that pops up for new database users so they can setup a new password. (I setup the user's name in the built-in security tools in Access.) In that form I have code to set the password from "" to the new one they set on the form.
See the code that sets the password...
Private Sub...
I see what your saying where it shows all the Null Values in the Form. Unlike you I'm seeing that both in the query and form.
I thought I had it with a IIF statement or Nz statement but it didn't work. I'll mess more with it on Monday.
Nice Fernando! That worked like a Charm! You saved me from a ton of aggravation.
That was driving me nutes. Even though I cleared the RowSource it was still looking at it as a currency. Wierd Access glitch.
Thanks!!
Telecom
I'm trying to re-create your queries and fields. I have two questions...
What table is your JobName field stored?
Not sure what you mean by FK. Do you mean Long Integer or AutoNumber?
Form Description:
Case "Price"
strSQLSelect = "SELECT DISTINCT tbl_Contracts.fld_Price "
strSQLFrom = "FROM tbl_Contracts "
Each of the 3 filters has three specific controls to set a particular filter. The Filter Field, the Filter Type, and the Filter Value. Controls...
I think I know what is happening here. It looks like you have the wrong name for your control in your code. You may be using the Label Name and not the Control Name.
A Control is a text box, combo box, toggle button, etc.
When you name your control you right click the control (not the Label)...