Search results

Hello and happy easter! Have a reports menu, and one of the options when clicked displays all invoices for every customer (in a report). When this particular button is clicked is it possible for some kind of list box to appear, displaying customers names, so i don't have to remember them each...

Good evening, writing a query, and i need to retrieve all dates before 12-04-03 for example. How do i do this?

Hello, simple question i hope, i have set a form to automatically load up when the db is opened. However, it doesnt maximise, is there a way of doing so?

Hello, I am trying to produce a report displaying a breakdown of details from my subform 'fsubEstimates'. Basically my sub form calculates values from combo/text boxes and stores them in a sub total (that is subject to change). Now i have been reliably informed that you cannot store a...

Hey, i have two questions: - 1. My subform uses combo boxes linked to indepedent tables to show values. These values once saved update fields in tableA. However when i lookup certian values in the tableA it displays primary/foreign keys. As im eventually going to create a report on the...

Good morning, Basically i have two forms 'Customer' and 'Job', a user can create a new job in the job form via a subform. Now there is also a subform in the customer form that displays all jobs for that particular customer. If a customer has NO jobs is there any way of making the customer...

HI, I have a subform that uses unbound controls to calculate a Subtotal from various text boxes and combo boxes. However i am trying to implement some error trapping because i dont want certain values from each combo box being calculated together. The basic scenario is ComboBox2 contains...

Hey, I had a calculating problem with a subform that Rich fixed. The fix that Rich gave me contained 1 list box and when i edited & implemented the code onto my form it worked ace. However i now want to add another list box, and use its value as another variable in my subtotal. Look at the...

Hello, As my forms contain more and functionality, im finding that menu buttons im implementing in the header are using up to much space. Is there a kind of menu structure guidance thats standard when using forms that contain many menu buttons or am i being a freak!!! Any advice welcomed

Hi - please find attached jpg of subform Currently trying to create a subtotal calculating data from the fields shown in the image. The values from the list boxes are obtained from two tables respectively. Each table contains three fields, Description (displayed in the list box) Primary Key...

Hello, When you tick a 'tick box' is it possible that an OnClick function can create other tick boxes with further options. (similar to layers in JSP, JAVASCRIPT code). For example, if i tick box A, can this event trigger a function that displays three other tick boxes B, C, D? A bizzar...

Hello, I'm having problems trying to increment the JobNo primary key when i want to create a new job. The code in comments is the code im working on. The rest of the code is the procedure that kicks in when the Add Job is clicked from a customer details form (that appears prior to the Job...

Hello guys, I have this problem and im not sure the scale of it. Basically the attachment enclosed shows my Job Details form that follows a customer details from...you get the picture. Now i can create a job in the sub form no problems at all, but when i go out of the form and return later...

Hello, Currrently working on a form with numerous fields. My question is how can i create a Save button that saves information entered into the form rather than going to the tool bar and 'Save record'? Ben