Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by integritycare

  1. integritycare

    Hi, I need to put the date in the

    Hi Duane, To answer your questions, Within the relationships the Branch table is linked to the User table (one to many) so when a new user is assigned to any branch he has a specific ID linked to that Branch. So it would be quite easy to put a dropdown on the form to select the BranchID. So...
  2. integritycare

    Hi, I need to put the date in the

    Hi Duane, This code is on a command button. When run, the report opens in PDF and when is is saved as a PDF with the ability for the user to input his Branch ID, however, Yes, there is a table with the Branch ID plus BranchName etc, but I am just not sure how to add this to the vba. This table...
  3. integritycare

    Hi, I need to put the date in the

    Hi Guys, Thanks for the info. I have now got it working quite well. have changed thee vba to read as below, Private Sub Master_Report_Click() Dim FilePath As String FilePath = "C:\PDFTemp\Master Report, -" & Format(Date, "dd-mm-yyyy") & ".pdf" DoCmd.OutputTo acOutputReport, "Master...
  4. integritycare

    Hi, I need to put the date in the

    Hi Duane, Just had to check the option explicit, Had missed out on a couple of forms. When you compile the Db now shows "Variable not defined on the strFullPath" But just not sure where to go from here. What is the better way to write this vba? Thanks KP
  5. integritycare

    Hi, I need to put the date in the

    Hi Duane, Thanks for your reply. Yes the DB does compile. It shows no errors.
  6. integritycare

    Hi, I need to put the date in the

    Hi, I need to put the date in the filename of an access report. I have tried this code as below. The report opens as a PDF OK, but no date. Got some error here. Any bright suggestions would be appreciated. Private Sub Master_Report_Click() Dim FilePath As String Dim FileName As String FilePath...
  7. integritycare

    Error 2465 Application-defined or object-defined error

    Hi Laurie.. Thanks for your reply. Just to try it again, I used a blank form (Form2) and used Recipes-New as a subform. On the after event of the Recipes New is below Forms![Form2]![Form_Recipes-new].Form.cRating Still have the same issue. When the form opens I just get this error, MS access...
  8. integritycare

    Error 2465 Application-defined or object-defined error

    Hi Laurie, Thank you for your reply. I had previously tried this reference plus many others! But still comes up with this error when you click on a star. Perhaps the only way is to make the recipe form a pop up form which works, and then the user can rate his recipe. What do you think?
  9. integritycare

    Error 2465 Application-defined or object-defined error

    Hi All, I am using some code by Daniel van den Berg re having a star rating on a form. On the subform it works ok.But when the subform is on the navigation Form (access 2007) it gives this error. The code below is on the subform Private Sub Form_Current() SetRating Form_RecipesNew, Me.cRating...
  10. integritycare

    Append Query

    Thanks Andy. The data base is a relational database as per the norm. Both tables are related, by the Primary & foreign keys. I had already created templates for them to use and with the option of removing items with a Yes/no option. I have created 5 templates which they can choose from. I was...
  11. integritycare

    Append Query

    Hi Andy,Thanks for your reply. Andy, I don't want to waste your valuable time so I will ask you a question instead. At the moment they use an excel spreadsheet which lists many items, this is printed out and emailed to the supplier. The management has requested that this data be held in a...
  12. integritycare

    Append Query

    Hi Andy, Yes the order No is in the Orders table so the Master and Child fields are linked by the Order No. In the relationships both the Order table and the Order Data table are linked by Order No. The Order form consists of the Mainform and a subform (continuous) If a record is added to the...
  13. integritycare

    Append Query

    Hi Guys, I'm in the process of designing a Chefs Order system. While its working as required I have been asked to provide the following. The order form works as per a continuous form using the Order No to link both main and sub forms. However as they order some 120 items each week, they don't...
  14. integritycare

    Comboboxes

    Hi Andy, Thank you for that post. It achieved what I wanted. 1. However just a couple of things about this combo box. I was wondering if the no of items listed can be extended. Seems to only select 8 rows. I used the design mode to see if I can look at the properties and increase the number of...
  15. integritycare

    Comboboxes

    Hello, I have a query re combo boxes in Excel 2007. I have a worksheet (worksheet1) with text data on it. I want to be able to put a combobox on another worksheet (worksheet2) and use it to fill in cells from the data on worksheet1. Just not sure how to implement this. Could I have some help...
See more

Part and Inventory Search

Back
Top