Search results

Thank you MajP, per your suggestion I will continue to save the form and from the VBE. I haven't had a problem since I started doing that and it really doesn't take any time. Thanks again, :) Gale

Thank you pbaldy... that's what I thought, I guess I simply didn't save the VBA changes. ouch! Gale

Hi, I recently lost some VBA changes and haven't figured out what happened. Recovery was simple so it's not a big problem but it caused me to question what I think I know about saving in Access. When I save from the VB editor it saves the entire database (its not split) so any form changes I...

That was it... thank you so much! :-) Gale

Hi, I need to enter the current Date/Time in a form field Txt_BARTinvoiceSub This form is used to update existing records. The recipient Table Field to be updated after I get the correct value in the form is formatted as Date/Time. The following results in pound signs ######## entered into...

Thank you theDBguy, that is exactly what I was looking for. It didn't occur to me to look for a form property. Gale

Sorry, in this context I am referring to records. I work a lot in Lotus Notes and they are called documents there... Records :-) Gale

Thank you VBA PHP. That is interesting and similar to what I think I need but I need it at the current Access document level. That may not be necessary though. I am starting to thing there is no such property and I just need to have a blank form to know I am creating a new document. Gale

Hi theDBguy, I don't exactly know. I used one of the canned button selections to add a new record. It appears to just clear the form... I was thinking there might be a document property but maybe I just need to clear the form and that will constitute a new document? Gale

I have a VBA import routine that extracts data from specific cells in an excel Worksheet. This routine must only be run on a New document. I also have a macro button to create new documents. How can I determine if a new document has been selected on the form? Gale

Thank you, that makes perfect sense. :-) Gale

Thank you pbaldy, that solved the problem :-) Can you explain why this works? If you just know it does that's fine... I am just curious because I would never have thought to try this. Gale

I have written the following to extract data from specific cells in an Excel Workbook into an Access form. It works until I try to write the extracted values to the form fields. I get a Compile Error "Methos or Data Member Not Found" on "Me.FormFieldName.Value = CellVal". How can I correct this...

Your function worked great. I wrote the following to test it... I know this isn't anything new to you but I'm posting it in case it might be useful to someone else reading this thread. Private Sub btnImportShortForm_Click() 'This sub calls the GetExcelData function to retrieve a value from an...

Yes, this is very helpful and I really appreciate it :-) I will let you know how it goes... Gale

LOL... I apologize, our messages are slightly out of synch, I appreciate your quick response. "No. I am saying you can use Excel Automation to "grab" some data from an Excel file from within Access." Thank you for the clarification... I understand now and that is exactly what I want to do...

Oops, sorry, I just noticed you provided a link. I would rather have the code in Access if possible because I don't want to change the Excel form (Workbook used as a form). It has been in use for a long time and getting everyone to switch to a new one would be difficult... but not impossible...

Hi theDBguy, By "Excel Automation" do you mean I should handle this from Excel rather than from Access? Gale

Hi, I am trying to find a VBA example that copies Excel data from specific cells in a Worksheet to an Access Form. All I am finding is examples of Access import. Can anyone direct me to a reference or provide an example? Gale

Thank you theDBguy, this is a very handy tip... one I am sure I'll use often :-) BTW, I tried to respond yesterday but I was getting server errors. Not sure if it was the host server for this site or something else but I couldn't connect to the forum. It's fine now ... Gale