Search results

Hi, I've the same problem and it works now after trying the code given there. Good work. But one thing i'd like to ask is that i've got "run-time error '2501'. the runcommand action was cancelled". This happen when i click on cancel instead of printing. Is there a way to get around this by...

Hi, I have a quick question that i need to get some help with. In a form, there is two comboboxes and a textbox. The textbox is disabled and locked because nobody is allowed to enter data to it. It contains the value which is from the result of choosing the two comboboxes. example; in table...

Hi, I was wondering if anyone might be able to help me out. Is there a way of programming the access database in such a way that it doen't shut the whole database if someone by accident, presses the cross sign which is right on the top right hand corner. I'd like it to ask the user if they...

It's been solved. Thank you

hi I need help here. I've been trying to fill in the textbox with some data in the report but it just won't let me assign a value to it. What's happening is i have two tables, tableA and tableB. The report is based on tableB however there are some fields such as contact, phone, reference that...

Thank you, Pat Hartman SOrry i don't get your first comment in regards to enclose the date in #'s. However, i've been struggling to execute the sql insert. Here is my code Private Sub Form_BeforeUpdate(Cancel As Integer) Dim mesg, TITLE As String Dim foundflag As Boolean Dim...

Hi, I need urgent help. I have a question to ask and wonder if anyone might be able to help me. My question is how do i execute SQL insert into a table called Job Register in access. Here is my code before update If foundflag = False Then 'new job detected StrSQL = "INSERT INTO...

Hi XXYY, hmm.. I got error message as soon as i put in the group by as follows SELECT [Job Register].Job_ID, [Job Register].Industry_No, [Job Register].Client_No, [Job Register].Job_No, [Job Register].Job_Name FROM [Job Register] WHERE ((([Job Register].Industry_No)=[CB_Industry]) AND (([Job...

Thank you Larry for your speedy reply and support. It doesn't work. It's me that didn't explain it well. Here is the rowsource i got from the combobox SELECT DISTINCT [Job Register].Job_ID, [Job Register].Industry_No, [Job Register].Client_No, [Job Register].Job_No, [Job Register].Job_Name...

Hi, I was wondering if anyone might be able to help me here. how do i stop the combobox to print multiple duplicate records? for example, in the combobox dropdown, there are records as follows 01 02 03 04 05 05 05 06 07 How do i ensure that it only displays the unique records only without...

Hi, I was wondering if anyone might be able to help me. What i'd like to do is to be able to get the access to trigger compact and repair database tool automatically just before it shuts. Is it feasible? or has to be done manually? Thank you in advance

Hi, I was wondering if anyone might be able to help me with this question. I have a form that is used for access authentication. In the form, there is a textbox for password and two buttons i.e. ok and cancel. My question is this. As soon as the user enters a password and hit enter key, i want...

Hi, I've a quick question. In Access, I have a form that allows user to add new record into a table. Is there anyway of finding whether the new record has successfully been inserted or added? So i think it may be wise to have a message to notify us of whether it's inserted successfully or...

Hi, I was wondering if anyone would be able to help me here. I have a form that has a combobox that contains a list of students and a button 'Go' that would produce a report based on the student selected on the combobox. My problem is say i have selected studentA from the combobox and press...