I need to create a report based on a form. what I need to do is copy labels and lines and rectangles from the form to the report. There is coding behind the next record button that needs to follow the labels and lines. How can I do this?
Cindy
there is a date function in Access that allows you to select records using today's date. if you are using a form you wod have to go into the VB code and type the following:
if me.expiry_date.text < Date() then
msgbox ("his card has expired.", vbokonly)
end if
Try this it should...
I double checked the spelling and it is exactly the same as in the table. If I take out the (inches) it gives me a type mismatch error but no parameters error.
Could it be because I imported the table from excel?
I am currently writing a program in VBA and when I execute the following SQL code I get a too few parameters expected 1. What is wrong with this code and why am I getting the error message?
dim Dbs As database
Set Dbs = CurrentDb
Me.STATE.SetFocus
tempgroup = Me.STATE.Text
sSQL = "Select...
I tried what you suggested, however I am still getting the same error message when I step through the code it stop on this line:
Set MyRS = MyDb.OpenRecordset([sSQL], [adReadOnly])
is there something I am leaving out?
I am trying to get my program to select records from a table using a field on a form as criteria, so that I can perform calculations on that data and return a value to another field on the form. I keep getting (Run-Time error 2465 Microsoft Access can't find the field '|' referred to in your...
Well I have the formulas for the box to move. This is my first application in Access, Now my issue is finding a procedure to call the record number of the percentile. I have a formula that finds the record number of the dataset that would be the 75th percentile but it doesn't return the value...
It is a statistical graph that shows how much of the data falls between the 25th and 75th percentile. the box is drawn between the numbers on a graph and everything inside the box is inbetween those two percentiles. I am not even sure it can be done in VBA but my boss doesn't want me to import...
I have a project at work that requires me to design a boxplot graph in Access - I have the form designed however the movement of the box isn't working the way I need it to. Does anyone have suggestions?
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.