Good afternoon,
I am currently working on this unbounded form that has numerous date fields. I wanted to know if it is possible to save data in a form, with a null date field. I am currently getting an error, and would like to know if there is a way around it. I am doing this feature just in case users do not need to enter a date for a specific record.
Also, when the form is loaded all the controls (checkbox, combobox,...
klove1209
Last Activity: Nov 6 '07, 06:49 PM
Joined: Feb 2 '07
Location:
-
Syntax Error For Null Date Field
-
Error Using the Export Picture Method
Good afternoon,
Can someone please assist me with getting over this error. I am trying to export a chartspace as a gif image. I keep getting runtime error 430- Class does not support Automation or does not support expected interface.
This is lines of code that i am using
Dim objChartSpace As OWC10.ChartSpac e
Set frm = Forms("frmPivot Chart")
Set objChartSpace =... -
Calling Function in Back-end
Good afternoon.
I need assistance with calling a function on the back end, that takes paremeters for a stored procedure. Then, that function returns the recordset back to the main DB. Below is the code for the procedures on the back and, and what I have so far on the front end.
**This function calls the stored query, with given parameters, and returns the recodset**
Public Function RSFromParameter Query(strMonthY ear... -
Calling Function on Back-end
Good afternoon.
I need assistance with calling a function on the back end, that takes paremeters for a stored procedure. Then, that function returns the recordset back to the main DB. Below is the code for the procedures on the back and, and what I have so far on the front end.
**This function calls the stored query, with given parameters, and returns the recodset**
...Code:Public Function RSFromParameterQuery(strMonthYear
-
Assistance with Word VBA
Good afternoon,
I am not sure which forum I should direct this question to, but any assistance is very much appreciated.
I have a word template, that is called from MS Access for reporting purposes. Within that template I would like to create a field, and have it updated with a Month/Year. The only problem is that the Month needs to be set to the previous month of any month that the report is printed.
... -
Database Heap Size and Creating Instance
Good afternoon,
I was asked to create an instance of my Database on a local drive and I am not sure how to accomplish that task?
I was also told to research on how to increase the heap size.
Can someone please provide me with direction?
Thanks, -
I tried using that also,
I got an error on the RecordsetClone.... -
The only problem with this, it that it is moving next about 10 records instead of stopping at the last checkbox....Leave a comment:
-
I got it working. Instead of using the recordset.count , I used Me.controls.cou nt!...Leave a comment:
-
I am getting an error with the .Count propert. It says the object doesn't support that property....Leave a comment:
-
There aren't really any event statements. It just the deselect button that I am not using. All my records return true/false statements back to a table.
Here is the code:
Private Sub Form_Current()
Dim chk As CheckBox
Dim Ctl As Control
For Each Ctl In Me.Controls
If Ctl.Properties( "ControlTyp e") = acCheckBox Then Ctl = False
Next Ctl
...Leave a comment:
-
it was already set to that....Leave a comment:
-
I just tested using the move next record button, and once I did that, it deslected each row as it appeared. I guess I need to have a movenext function in there?...Leave a comment:
-
Ok I did as you suggested. When the I switched it to form view, only the first row deselected. All the other rows remained the same....Leave a comment:
-
Thank you so much. Now the only problem is that it work for 1 out of 22 records. For each row (record), there are about 22 check boxes, so in actuality, I need to clear about 400 check boxes....Leave a comment:
-
Deselect a Group of Check Boxes
Good afternoon,
I would like to know if anyone can direct me as to how I can write a VBA code to deselect about 26 check boxes, for all records.
I have been searching the internet, but I haven't came across anything.
Right now I have a command button on the form, that is able to deselect one checkbox for a single record. I don't want to have to hard code in all the checkboxes names into VBA.
... -
Hi, thank you for your assistance, but I am still getting a type mismatch error at that same line....Leave a comment:
-
It's an access project....Leave a comment:
-
ok so basically, i have a SQL string in a module. When this module is ran, I would like the third recordset to be returned to a query in the database.
I found some code to help me, but it's giving me a type mismatch with the object rs.
...Code:Dim rs As Recordset Dim qdf As QueryDef Dim db As Database Set db = CurrentDb Debug.Print IndName Set qdf = db.QueryDefs("Query1")Leave a comment:
-
Passing recordset from module to a query
Good morning,
I would like to know if someone can guide me as to how do I return a specific recordset, from a SQL query that is being ran in a module, to a query. This query would use the return string as a parameter to return specific information.
Any ideas?
No activity results to display
Leave a comment: