Search results for query: *

I looked there. Didn't really have anything about creating a form. Michael

What is the easiest way to create a form using code?

Thank You for your quick response. I am going to use the form during the player draft. When there name gets picked it will become not visible. Michael

I would like to create many text boxes on a form. I would like to know if I could write code that would create text boxes based on numbers I have in a table. We have baseball players each has a number that reflects their age in this table. In this example of 7 year olds, Example: Joe Smith...

What method is that?

This is not practical. We have salesman with laptops. They meet at the office each week, where they can update the data as needed. Just don't know how. Michael

I have address data stored in Excel. Everytime we add a new customer, we add the address to this list. Is there a way to transfer this data to an Access table? And possibly weekly update to the same table. Or! each of our salesman have these addresses in Outlook. Could I do the same thing...

Try IIf(IsNull([fieldname])

I also found this after researching: or PDF995 (free - try google, or if you can't cope with it starting up a URL each print, multi-user licences are peanuts) or CutePDF (not sure of the spelling or the price) or ... many other free/cheap/good PDF writers i'm sure: try google. Michael

THE KEY IS Acrobat PDFWriter installed on your machine. I have 4.0 writer. It works great. You pick what record you want to print, then select PDF Printer as your printer and it makes a file. The other thing is, is maybe saving as a webpage. Everyone that has internet access, can usually...

You must have Acrobat PDFWriter installed on your machine. It is set as a printer type. To print to pdf. you display the report and then select the Printer name of "Acrobat PDFWriter" and then it creates a pdf file. Hope that helps.

I use 4.0 and it worked just fine. I think I researched Google and figured it out. I will try to research myself to help you with an answer. Michael

Try If me.fieldname.value="" Hope this helps, Michael

I had the same issues. I converted it into a .PDF file. Then anyone that has a PDF reader can view it. You have to have Adobe Acrobat reader though. If you do Adobe acrobat has instructions on the process. Hope this Helps, Michael

Yes! Thank You so much. This seems to be working very well. I even added another line at the end DoCmd.GotoControl "SpecialInstructions" It seems to be doing fine!! Thank You for your patience... I am very new when it comes to coding. And you are very kind Michael

This is the area that is highlighted: a = Split([SampleNumber], "-") When I have the mouse over "a" it says empty When I have the mouse over "SampleNumber" is says WIL-215 WIL-215 is the previous Sample number

Here it is : Private Sub CopySample_Click() Me!SampleNumber.SetFocus DoCmd.RunCommand acCmdSelectRecord DoCmd.RunCommand acCmdCopy DoCmd.RunCommand acCmdPasteAppend DoCmd.GoToControl "SampleNumber" a = Split([SampleNumber], "-") a(1) = a(1) + 1 [SampleNumber] = Join(a...

I tried Dim strNo As Variant with no luck

Would I add this as a function in the code? And Where? Michael

I don't know the process to do that? Breakpoint? Michael