Search results

Do you have a "Desktop" folder in your shared Public folder? Does that code actually work?

It would look like "C:\Users\" & Environ("USERNAME") & "\Desktop\End Of Month.xlsx"

These are some code examples from Optic Prime Here is email using Outlook: Public Function EmailOutlook(ByRef email_to, email_subject, close_outlook As Boolean, Optional email_body, Optional email_attachment As String) Dim outlook_app As Object Dim outlook_item As Object On Error GoTo...

Access should be used when you need to have consistency and control over data entry into a relational database, spreadsheet programs like Excel would take a lot more work to have that type of setup.

So your table would have a Person_Sending_Parcel field, a Sending_To(or more like a customer ID that relates to another table with the customer information) field, Confirmation field (so you can print a slip receipt based on that field), Service_Type field... When you said "provide a tracking...

I made a sample database that you can modify to fit your needs here: http://www.patrickcool.me/OP/OP.html edit: I saw you specified 2013, my example is 2010 and might require additional tweaking.

I need one more post to post links

there is an example of using a form and subform with permissions in the sample file from this website: www.patrickcool.me/OP/OP.html

I think you are right. Users shouldn't need to add fields. I'm just going to do what the link you provided me with does. Thank you for the help! :)

I could just make a table with fields labeled "Categories" and "Sub-Categories" and then run queries like the example you showed me.

Thank you for being quick to respond! I'm trying to make it so the user can add fields and then choose a combobox with the fields as values, and then choose a separate combobox that shows the values under each field. I have attached a sample of what I want. There is probably an easier way to...

I have a combobox1 on form1 that has "fields" from table1 as its values, I want another combobox2 on the same form1 to populate with the values based on the fields in combobox1

is there anyway to run vba on the first record only? I want to run a conditional statement during the OnCurrent event. Something like Private Sub Form_Current() On Error GoTo Form_Current_Err If Form = FirstRecord Then MsgBox "First Record" End If Form_Current_Exit: Exit Sub...

Yes I think that is what I want, I would have to see an example to confirm it though. Do you have an example on file?

Is there a way to populate a textbox on a form depending on a combobox(This combobox is based on a column in a table) using SQL? I am currently using the Dlookup function, but want to know if there is some way I could use the SELECT statement.