Hi,
Trying to create a 4 fold Birthday card. This means that when it is printed, on the top half of the a4 sheet, all the text has to be upside down! Does anyone know if this is possible??
Don't worry everyone, I found the solution on a website. Here is the answer.
with rst
.addnew
'Add all the stuff that you want to the recordset
.update
.bookmark = .lastmodified
end with
Say I have a couple of recordsets open that I am using in a module with no form. I want to add a new record to one of them, and then make that record the bookmarked record, or the current record. Usually I just use me.bookmark, but because there is no form it does not work. How do I set the...
Say I have a couple of recordsets open that I am using in a module with no form. I want to add a new record to one of them, and then make that record the bookmarked record, or the current record. Usually I just use me.bookmark, but because there is no form it does not work. How do I set the...
The reason that the definition of database is not recognised is because you have to add the microsoft DAO 3.51 Library to the references of the project. In the code window go to tools, references. Make sure the priority of this library is greater than the microsoft ActiveX data objects library 2.1
I want to be able to determine which form has opened another one. For example, if you have a calendar form with a simple calendar control in it, and this is opened from 5 different locations. When the calendar is closed it is meant to insert the date into the form that opened it. How can I tell...
I don't think you can do that with a combo box. You can probably make your own custom menu that pops up when the form opens, and can pop the values that you want into the desired control.
Hi Hommer,
In the form, in the general declarations section of the code window delcare a variable
dim password as string
Then in a new section paste this:
Private Sub Text1_KeyPress(KeyAscii As Integer)
password = password + Chr(KeyAscii)
End Sub
Replace text1 with the name of your verify...
Or you could create images in Paint Shop Pro and import them into access. Use the onclick event to mimic buttons. As for changing the colour of the tab controls, I have never seen it done.
Open the datasheet in the design view. right click on WorkOrderNo, select properties, event, double click, code builder.
Paste this in.
Dim stDocName As String
Dim stLinkCriteria As String
stDocName = "frmWorkOrderEntry"
stLinkCriteria = "[WorkOrderNo]=" & Me![WorkOrderNo]...
Click Tools, startup, and then uncheck almost all of the options there. Then go and remove all of the menu bars by right clicking on them and hitting customise. Set them to not display. Backup the frontend before you do this however, because sometimes you can lock yourself out of getting into...
In the "On Load" Event of the form you would place this line.
DoCmd.GoToRecord , , acNewRec
For common functions like this, use the wizards for the command buttons like new record, delete record, go to record etc, and then cut and paste the code to the event that you want. That is...
Thanks Heaps Toeshot
that dbOpenDynaSet was the trick. Works like a charm. Looks like that rs.findfirst really only works with the dbOpenDynaSet. Once again Thank you very much.
James
How do I create a recordset with the criteria being the primary key on an open form?
eg form is open with numeric field chargeID
rstTemp.openrecordset("select * from tblChargeProduct where ((tblChargeProduct.ChargeID)=[Forms]![frmCharge]![ChargeID])
This looks like it should work to me. Can...
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.