Search results for query: *

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

Is there any way to edit forms after the DB has been converted to an MDE? Is there some kind of tool I can use?

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