In my form under 'control source' i have input my datediff expression but it is returning result #Name?, so am not to sure what I have got wrong where. I am...

I'm currently creating a database that assigns problems to people that could solve them. I have a table called "employees" and one called...

What I try to do is make my addnew subform visible on click... Private Sub Kommandoknapp74_Click() If Me.Kommandoknapp74.Caption = "New Call"...

I am trying to calculate the number of days between a StartDate and EndDate in Access while ignoring the weekends and holidays. I copied code and directions...

I can get this to work in a totals query but not on a form. I have this for the control source: =DCount("","pickupreqdatafrm","=me.reqdate AND...

good day all, Currently I have two different forms setup along with two different queries based on my tblcheckingaccout The reason being is that I have...

I have a report question if anyone could help. I have a query that I want to drive a report. The query can have multiple lines of information driven by an id...

i am very new to access. i have a form with one text box that pulls the client name from the main client info form, and one subform that allows me to enter a...

Hello I have Text Box and it have is code like this: = & Chr(10) & Well, my question is: Is it possible to make on left side the with Blue color and...

I have this simple procedure and it isn't working. I am sure it is something really simple that I just haven't considered. I could program it another way but...

Thanks for your attention How can I set true a check box without click the...

Hello! Thanks for your attention. I have the form Invoice, and inside it there is a subform named Invoice's Details, in the form Invoice I select one costumer...

I am creating a data entry form and I would like to have a claim# for each entry I would like the claim# to be something like CCA-1 and then count from there...

I have a main form with customer information and a subform with details of the sale. I have a table with the tax codes (i.e. non-taxable, taxable at...

I have a subform that has the Following Fields: Date Equipment = combobox Qty = txtbox Recieved = checkbox Shipped = checkbox Category = Combobox Comments =...

I've got a simple application with one button control in my form that triggers a few queries which take a few minutes to run. I use a label control to display...

I am trying to link client site which is on C drive (local) to my database which is on network ( T drive). It gives me following error "The file is located...

I am having trouble getting this to work. I have a current form that states "." in the "Order By" field of the form properties and it works as it should. I...

Hi, I have a combo box linked to a SQL2K table's column (INT) which stores our policies numbers. The numbers vary from 100 to 35000 and counting up. What's...

Thanks Allen. Your solution does work fine in so far it indeed "carries forward" the records. My posting title and the text inside may have been a bit...