This is what I want to happen.
The form opens and several fields are manual entry for the user. When its all filled out correctly, they hit a save type button that saves the form and sends it to the next level to continue. When it gets there, the status changes from "new" to "escalated" and...
I want a button to send an email with a button in it that adds the db to the user’s workspace and opens up a form in edit mode. I can create the email and I can create the button manually, but I can't seem to find out how to have that button created inside the email through automation i.e., not...
Does anyone have a link to download the latest LotusNotes SQL driver for quering Lotus Notes tables via SQL through an ODBC connection?
We updated to Notes7 and our old driver isn't working anymore and I can't seem to find the driver on notes.net
Dominus Nihil
(Master of Nothing)
I created a db with an access front end and three SQL back end tables. The users enter information into the access forms and its supposed to write to the SQL tables. On one form, this works perfectly: You hit a button on a menu form at it pulls up the data entry form as a new record.
Private...
Is there a command that will provide you with the path of your database? I want to use the transfer spreedsheet command which requires that I provide the path of the file I'm transferring. The problem is that there are multiple front ends and the table is located on each front end. After the...
I built a database on access that uses a SQL server for the back end tables. That part works great but the business group wants to add a new feature that allows them to append records onto one of the tables from Excel spreadsheets.
I'm thinking of doing this in two parts.
1) import the...
Can you use two text fields in the criteria section of the Dlookup function?
I'm trying to create a feature where it takes the user's network ID using
Me.TempID = Environ("username")
and then compares it to a table where I have various users which I want to have exclusive access to a...
I checked the FAQ and ran a few searches and couldn't find anything matching my issue.
I have a simple form that has the user enter an account number and date into unbound fields and then push a button. I need assistance taking the values of these two fields and passing the data into two...
I would think this would be a common request and thus already covered in some thread or another but I've been looking for a few hours and didn't see any. If this has already been covered somewhere that you are aware of, please point me in the right direction.
Here goes:
I created a database...
How do you create a database update feature that updates the various front ends to the latest version?
To clarify: As a noob, my normal method for distributing my database is to send them the front end via Email attachment. Every time I change the database I need to send everyone a new...
I'm trying to take an attachment saved in an Ole Object field on my main Access form and attach it to the body of an Email (using Lotus Notes).
I was write the code to send the Email but I must not be doing the Attachment part correctly because it just shows up as something like |$| instead of...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.