Search results for query: *

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

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

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

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

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

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

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

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?

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

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

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

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

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

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

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

Thanks Duane, for that.. kp

Hi guys, Thank you for your replies. Both "Total" and "expense" do have null values. When the query is run the Running Balance does not show any results. Here is a copy of the query results Invoices Expense Total RunningBalance 2 $100.00 4 $200.00 5 $300.00 6 $50.00 8...

Hi Duane, Many thanks for your reply. I cut and pasted this code,into the query, but I am not able to get a running balance in the query. Its just blank Do you have any other ideas? I googled sub-query and had a fiddle, but had no luck.. Thank you,, KP

Hi all, Just a question on running totals in a query I have used this code below to give a running balance RunningBalance: DSum("[Total]","Accounts","[Invoices]<=" & [Invoices]) However I want to add an expense field to this so we have an income and expense running balance. I have an "expense"...

Hello, I have a question about locking an Excel workbook on closing it down. Is this Possible? Particularly the cells that contain a users input. Many Thanks, KP