Search results

lol ... thanks ... its a bit more technical than my experience allows me to understand. i will return to this after i learn about option groups. thanks

option group ? whats that ?? im a noob... this is the first time im attempting to use an option button Private Sub orgCheck_Click() Me.orgname.Enabled = True Me.orgaddress.Enabled = True Me.orgtype.Enabled = True Me.orgcontact.Enabled = True End Sub this what i have so far

i have an option button, which onClick will enable some textfields. is it possible to disable the previously enabled items when the option button is clicked again(unchecked) ?? and if so, how do i do this ? please and thanks

Public Function MaxCID() As Long MaxCID = Nz(DMax("CustomerID", "CUSTOMERDETAILS"), 0) + 1 End Function this mod returns the next available integer CustomerID is there a way to modify this existing mod to SPLIT & INCREMENT a STRING Id, P100, to return P101 ??

did as you suggested. same error persists. i totally wanna know whats happeneing here. . thanks man

so i took you advice with the .Value thing. however the error still persists even after i declared an integer variable and assigned CustomerID's value to it. CustomerId control is a text box in which an integer is entered.

and i still get the same key violation error

yes sir on numerous occasions, ive also made sure to enter only numbers

this is my query: DoCmd.RunSQL "INSERT INTO CUSTOMERDETAILS (CUSTOMERID, CUSTOMERNAME, CUSTOMERADDRESS, CONTACT, EMAIL, ORGANIZATIONTYPE, ORGANIZATIONID,STATUS) VALUES (" & Me.CUSTOMERID.Value & ", '" & Me.cusname.Value & "', '" & Me.cusaddress.Value & "', '" & Me.CONTACT.Value & "', '" &...

After trying multiple suggestions, i got it working guys. thanks a million

thanks

thanks

sorry i replied to the wrong response

ok thanks, but im a nub at this. could you provide more details plz ? how do i go about filtering a report ? im opening the report to preview using the predefined button provided by access.

ok thanks, but im a nub at this. could you provide more details plz ?

how exactly do you exit the combo before running the query ?

i did as instructed, and the new field shows no info, however the query returns all the data for all the customers. 1. i wanna preview a report via a button. 2. ive attached the report to a button. 2. the report is made from/attached to a query. 3. the query is supposed to get its ID from the...

i have a query that will return all records for a customerId, however i want to link this query to a form so that the correct customerId will be passed to the query to be used as criteria. in the Criteria field, i put [Forms]![AddNewRental]![Combo19] but it works only sometimes andit keeps...

a bit clearer. if i encounter any more issues, ill return. thanks man

thanks. so id say if CurrentProject.IsLoaded = frmAddnewCustomer Then blah blah blah ?? frmAddnewCustomer is the name of a form