Search results

What about the format on the form? Is currency with 2 digit decimal as well?

This thread has a good example of allowing user to select a file using the standard open file dialog box. http://www.access-programmers.co.uk/forums/showthread.php?t=170548 Just download the Access database "FileDateModifierz.mdb"

There are couple ways to do it. 1. Set up a set of default values into a table that stores characteristics for a particular machine. When new machine is added, you can select those characteristics from that table and apply to the new machine. 2. When adding new machine, you will need to...

Perhaps, describe what you are trying to accomplish rather than explaining your record results so we have a better picture of what's going on. Peace. EZfriend

Can you just sort the data by Date1?

Textbox is default to 50 characters, but it can hold up to 255 characters. You just need to change the field size to 255.

Look at the Save or SaveAs With doc .SaveAs ..... .Save ...... End With

Thank you both.

You should always have a unique key in a table. Create another autonumber field for your ServiceMatrixDetailstbl then leave the ServiceMatrixID in your ServiceMatrixDetailstbl as is. That is your FK.

When I run this in Access, I get an error. ALTER TABLE [tblName] ADD COLUMN ReviewComplete BOOLEAN What's the proper way to alter table with boolean field. Cheer. Thanks. EZ

Post your db here so everyone can see it.

In the do while loop, you need to check to see if an email is actually exist. Private Function GetAllEmailAddress() As String Dim rs As Recordset Dim sRecipients As String Set rs = Me.Recordset sRecipients = "" rs.MoveFirst Do While rs.EOF = False 'this will add the email to the TO...

You could probably declare two ADOs connecting to both database and then ADO1 is to pull record from database1 and then using ADO2 to insert into the second databae. Sample Code (not tested yet) Private Sub DoThis() dim rs1 as ADODB.Recordset dim ssql as String...

Go to File -> Page Setup -> Page tab -> Use Specific Printer -> Printer... then Browse and chose one

sRecipients = sRecipients & rs!Name & "" shoud be sRecipients = sRecipients & rs!vendorCompanyEmail & ""

you should also use the select statement Private Sub SelectStatementExample(byval sVal as String) Select Case sVal Case "A" 'do something Case "B" 'do something Case "C" 'do something Case "D" 'do something...

Well, you will need to create some sort of "Edit" button and when that is clicked, you will bring up the for "frmWrkDetails" filter based on the parent ID (VisitID). The "Default" value for VisitID on the frmWrkDetails should be set to the parent form VisitID.

Isn't it depending on how you position your subforms during design time? You just have to make sure that they are align correctly (left & top position)

Before sending to outlook, you can call a function to collect all recipients using recordset and return it back to your click Private Sub Command24_Click() On Error GoTo Err_Command24_Click Dim stDocName As String stDocName = "frmVendorSearchEditCommodity" ' DoCmd.SendObject...

You will need to add the click event (perhaps, double click event) for all of the fields and when any particular field is click (double click), open your second form. You can use the same query for your second form. On your DoCmd.OpenForm, you will need to filter the record using the selected...