Search results

Simple use a report.

I don't know if this will work on a tab form, however when you have a command button on the main form and you want to go to a new record in the subform , you must first set the focus to the subform. Hope this is some help. Below is code from one of my db's. Private Sub...

jmceuin, Your welcome. For what it is worth I agree with Mr B, you should have a "back door" into the data. However in the end it is your database and this is only 1 ( or 2) persons opinion.

Put this code in the OnCurrent event of your form; Change txtBoxNumber to suit your situation Private Sub Form_Current() If Me.NewRecord Then Me.txtBoxNumber.Locked = False Else Me.txtBoxNumber.Locked = True End If End Sub

Why do you have to double click to add an item to the list? Have a look at the attached sample, just type the new data into the combo and it will ask you if you want to add it to the list, select Yes and that's it.

I am using Access 2003. Try this code (it's not mine I just have it in a sample - it works fine). Change the name of the table and field to suit yours. Change the name of the combo box to suit yours. If you still have problem I will post the sample for you. Private Sub...

Answer to your questions = Read my original post. and read the code in the databases.

I have just had quick look at your code and I see a couple of errors; objWord.Documents.Add ("C:\Documents and Settings\asr0245\My Documents\Grain Bids\bids form dec.doc") This should be a template in word and not a normal document. I would also name my template bids_form_dec.dot I don't like...

Open you form in design mode, then go to your code window (Alt+F11), then to Tools / References, Select your version of Microsoft Word Object library you will see in the attached JPG file mine is 11 (2003).

raginggoat, If your last post is in response to my post then I don't understand your statement. You don't even acknowledge my post. Did you look at my sample? If you did then did you try and adapt it to your situation? or do you want someone to do it for you?

raginggoat, Have a look at my samples posted here There are 2 samples, One using single bookmark and the other using multiple.

Open your report in design view, right click "Detail" select Properties and put the code (in bold) in the OnFormat. Change MyMemo to the name of your memo control. Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer) Me.MyMemo.Visible = Not IsNull(Me.MyMemo) End Sub

What is the "value" is it fixed or variable? Have a look at my attached sample it should give you an idea how to make it work. With my sample you can click it every couple of second and you will see that it updates.

Have a look at the sample I posted here Any further questions post back

DocController, Sorry have not used 2007 as yet, so I'm no help to you.

What version of access are you using? Your wrote: Your don't print forms (they are for data entry) to print information you should use reports. If you have to sent data to users who do not have access then you can send them a copy of the report via email from within access.

I don't understand your reply my post never said anything about;

missinglinq, Are you referring to my post or the one by JANR? In my post I used txtStartDate, but it was not in the other posts.

This is the code I used (note the names of the controls); Private Sub txtStartDate_AfterUpdate() If IsNull(Me.txtStartDate) Or Me.txtStartDate = "" Then Me.chkStarted.Value = False Else If Not (IsNull(Me.txtStartDate)) Then Me.chkStarted = True End If End If...

Sue, Have a look at my sample posted HERE, go to the bottom of the post and you will see the attachment with this name: PrintCurrentRecord_Update.zip Open it and then click print Preview Report button, when the report open have a look at the top and you will see the Printer symbol and Close...