Search results

I have a data base which a main form with the customer info on - the db has been pre populated with around 500 records so all the cusotmer name and address and so on is already there. what happens is when someone speaks to the relevant customer they can create a call back or just leave history...

hi is there any way that i can increase the value held in date() by 1 year or 2 or so on? regards

HI I am trying to populate 3 list boxs with data from a table. I have the below code but all i seem to get is the table name or sql statement entered into the listbox. I wonderd if anyone had any ideas? Code follows: Option Compare Database Private Sub Form_Load() Dim...

HI I finally got a function to sort of work but cant understand why it is doing certain things the idea is that it calculates the total of Pubprice and then inserts it into the TestPayment field. Now the function only works on the first customer on the comp screen but when you change to...

I have just really started looking at using VB to run main functions in my forms to ease up a bit of processing time. I used to have a sum which gave a total on screen for the selected customer but this would never write to the main table so i was unable to use it at a later date without having...

Hi have a query which looks up a bunch of values across 2 tables and i have a parameter which prompts user to input a date and i then want all records matching that date to be returned but it just returns all records: The sql for the query is a follows: SELECT Tbl_Customers.Customer...

How can i setup a popup message when the user closes the DB. I need to have an reminder to the user every time they shut the program down!

i have a sub form which on the click of a button sets 4 fields Private Sub Command8_Click() LastPaymentDate.Value = Date NextPaymentDate.Value = Date + 7 AmountPaid.Value = [Form_Frm_Customer]![Payments] [Form_Frm_Customer]![Payments Due By].Value = Date + 7 End Sub It updates all the fields...

Hi Im currently building a database which holds customer delivery options, quantities, unit and delivery price and so on. It has all been going fine until now...! I am trying to setup the billing aspect. My main headache is that each customer could have a delivery every day, of different...

I have a main customer form that displays all information for that current customer - There is a button for add new record which then gives the blank screen with all the fields empty. What i want t to do is when the add new record button is clicked various input box pops up asking for name...

Hi I have a report that list all customers. My only problem is that it only orders them by the first number of their address because it has the street name as well. Eg: 1 Bedford Street 22 Bedford Street 3 Bedford Street and so on. I did have the the number and street address in seperate...

One the face of it it sounds quite simple - i have a table that holds various bits of info about a customer but also a field that contains a holiday period - what i want to be able to do is show all records that do not equal todays date. So if today was 11/04/06 - and one of my customers had...