Search results

i am having some problems with some code i am trying to write. I want to open up a sales form for a customer. I am keeping it to one sale per each customer. the problem i am having is i want a NEW form to open for each customer. After the new form has been opened and data has been entered and...

Hi i seem to be having a problem with my database. I have a customers, appointment and appointment details table and forms. Whenever i enter a customer and add appointment details, close. Reopen it and click the appoitment button to bring the appointment form up and it will create a new record...

Is this possible in Microsoft Access? i know its possible in c# but ive never really got into Microsoft Access until now. Enter a Postcode , logs onto a website and fills in a combo box full of possible addresses

has anyone created a diary in microsoft access or heard of anyone who has? I want to make a diary of appointments for certain people so when someone is making an appointment they can assign whatever rep is free for whatever time. Is this possible to have it layed out like a journal in say...

hI i was wondering if anyone can tell me if its possible to have several users accessing the same database, adding records, deleting them all at once? Ive never tried this before because ive only ever created databases for one user?

Is it possible to use a regex in Access on a text field? i want to allow... L000000 A letter and 6 numbers the letter can ONLY be W or C then any numbers after? How would i do that in access? would i need to use substring? even so regex in access would be fine ;)

How do i count the number of rows in a report?

How do i execute another procedure inside a procedure? Cheers

Atm i have a Query which will display all values in a table within a given date range. I was wondering instead of displaying all values how do i filter the results to ONLY show the ones i want them to show. For example: Filter them by Rep called bill Jones? (user inputts whatever bill jones was...

I am having a problem with one of my queries, the problem i'm having it seems to be returning the same value 3 times and other values overwrite themselves. Ive attatched a image because i cant really explain it. Can anyone help? Here is the SQL: SELECT Customers.FirstName...

Does anyone know how to reset auto number?

How do i make a page (tab) in a tab control come to the front? atm ive got tables changing from visible to not visible. I prefer to make the pages come to the front any ideas?

Private Sub RepCommissionBoxGroup_AfterUpdate() If Me.ckbRepCom1 = True Then Me.tboCashCommission = Me.tboRepComFig1 End If If Me.ckbRepCom2 = True Then Me.tboCashCommission = Me.tboRepComFig2 End If If Me.ckbRepCom3 = True Then Me.tboCashCommission = Me.tboRepComFig3 End If If Me.ckbRepCom4...

Ive made a button to + 0.5 to a text field the vba code is simple Private Sub btnDiscountUp_Click() Dim DiscountValue As Double Dim Temp As Double DV = DiscountValue Temp = DV + 0.5 tboDiscount = Temp End Sub However it ONLY works once, if i click it again it doesnt add another 0.5 on. What...

Ive created a button using the wizard here is the VBA code for click event: Private Sub btnOpenSales_Click() On Error GoTo Err_btnOpenSales_Click Dim stDocName As String Dim stLinkCriteria As String stDocName = "Sales" DoCmd.OpenForm stDocName, , , stLinkCriteria...

whats the vba code for checking to see if a checkbox is ticked? its Checked or something isnt it? please can you provide me with an example because i want to use it in a if statement. Thanks

How do i save data in a textfield where i do calculations, if i was using a normal textbox which asked for simple text input i can add a control source and save it in that field in whatever table. If i add a calculation/ formula to a field i loose the control source option. Same goes for when i...

ive got a problem with my Cascading Comboboxes, they work fine and update to whatever thing you choose. HOWEVER on my LAST level of combo boxes ive got several numbers listed based of product. Whatever product i choose first the numbers after will be the same for ALL other products. It doesnt...

how do i cant the number of rows/ records in a table and display it as a number in the report?

How do i make a report prompt a start date and finish date based on a table field to which it should pull data/rows from?