Search results

Thank you so much!! never imagined those quotes were the cause of the problem..!!

Hello everyone on my database I have a form named frmGoToRecordDialog when I select a customer and click show record it should open frmCustomers on that record of the customer selected but instead I get run time error 3464 data type mismatch in criteria expression. Can anyone please help me...

Hi Jdraw, I fix that but I'm getting a new error Subscript out of range & it highlights this line If strName(intItems - 1) <> "" Then Could you help me please?

Hi everyone, I was hoping someone could help me with when I click the add bottom I get Compile error expected array & it's suppouse to check for a value in both text boxes, if either one is missing a message box should let the user know that they need to provide a value for both and this part...

Thank you! it's working now, I didn't quite got what you were saying at first but now I do! Thanks again!

Hi, I tried the hint with the after update event on the end time field and after I change the start time it doesn't automatically change the end time. Before I add the get focus part of the code it does change It but on the start time field but when I add it it doesn't do it anything.

Hi CJ_London, I tried using both if your suggestions and the first one did work but I still need to do something else.. here is what I was told to do: On the Classes form, if the user enters a time in the Start Time field, set the value of End Time to 3 hours later (Hint: fldEndTime.Value =...

Hi CJ_London, I tried it with an after update event but didn't work can you please help me more??

Hi everyone I'm new to programming and MS access I have a form fmrClasses and what I'm trying to do is write a code that as soon as the user types a beginning time will update the end time to 3 hours later for example If user enters 9:00AM for beginning time the end time will be set to 12:00...

Hello everyone, I'm trying to construct a form with a option group that when Selecting the Fotheringham radio button will filter to all records where the instructor field contains the “Fotheringham”. Selecting the All Classes radio button will remove the filter. I'm not sure why it's not...

Hello everyone I'm new to macros(: I'm trying to create a macro that will: getsinput from the user the location of the cell where the sum should appear. eg. user enters F6, macro will display the sum of cells B6:E6 in F6 and finish with the active cell being F6. Here is a snip of my code that...

here is a snip of my code with the change I tried and the database with the form as well essaytee, hope you can help me, don't really know what to do

Anybody have other suggestions??

I did but I can't still make it right :(

Hi here is the snip of the code:

The instructor didn't give us that information, he only said our form should look like the one in the example.

Hi, this is what I was told, I thought it was supposed to loop 3 times but this confused me: To determine the value of compound interest, the following formula must repeat (loop) number of years * 12 (e.g. if it’s a 5 year mortgage, then 60 times; if it’s 10 years then 120 times etc.)...

Hi Galaxium unfortunately I'm required to use loops, this is part of an assignment and my mean instructor is requiring us to use loops for this, if not I will get a 0 for this even if the answers are right. could you please help me?? :( we are also require to use this formula: TotalVariable...

Hi Markk thanks for the help base on your advice I cleaned my code and now it works!! but I don't get the right answer, could you please help me?? Also how can I change the color of the letters in the result.??.Thank you!

Hello everyone I really need help im new to VBA and having a hard time understanding loops. I'm trying to create a compound interest form using loops and the following formula: TotalVariable = TotalVariable + (TotalVariable * (RateVariable / 100 / 12)) I'm not sure whats wrong with my code...