How can I position a form (progress bars) at the bottom left of the screen regardless of other factors such as resolution. I have seen this done for visual basic and delphi but I haven't bee a...
Experts,
My form has a list box. I would like to open the form but I do not want to show a blank list box.
I have a small query which I want to use as the basis for a Crosstab. What I am hoping to build is a simple view of a production schedule which displays the Line Number, with the Date and the...
I posted this earlier but have yet to resolve it. I currently have the visibility of the Co-Borrower fields hidden (Example 1) unless the CoBorrower check box is checked (Example 2).
This ...
I have a query ordered by date (qrySimpleInterest). One field is TotalClaim. I run the query, but then I need to extract the last figure in the TotalClaim field so that I can assign it to a ...
Hello everyone!
I have a treeview control that is built up from records with a recordset. I can choose an item in my treeview control and it will allow me to open a form and goto that speci...
I have two fields - date and time in Access. They work fine.
However, ArcMap doesn't support a time field, so now I need to combine the date and time into one (new) field. The new field m...
I have the following code to open pdf files:
Shell ("C:\Acrobat3\Reader\AcroRd32.exe " & strFileName), vbMaximizedFocus
How do I change it to open Doc files in any XP environment?
Tha...
I need to calculate two fields together that are formatted in "time". The attached code snippet is the append button code that I am trying to use to add the current stop watch value with the s...
Hello,
I need help (a lot of it) writting a query (for MS Access) to produce the below report. There are actually more columns than this needed in the report, but if I can get this many, I ...
I have some code which generates an HTML-formatted Outlook message. My problem is that the line spacing appears to be double-spaced but I want the text to be single-spaced. Here is a sample ...
I have an Access form for inputting some data but I need to grab 3 select fields values and pass them off to a printer before the form data is inserted into the data base. So what is the best...
Can't get the insert to work help please
Private Sub Detail_Click()
Dim db As Database
Dim rs As Recordset
Dim db1 As Database
Dim rs1 As Recordset
Dim varserversql As String
Set ...
Every now and then a few records in some tables become corrupt.
How can I determine if corrupt records exists so that I do not end up with ALL my backups containing corrupt records.
Is t...
Experts,
I have two command buttons on my form. One executes Docmd.GoToRecord, , acPrevious and the second one executes DoCmd.GoToRecord, , acNext.
What I would like to do is to replace the ...
I have a MS Excel file with the data that needs to be loaded into MS Access database through MONARCH.
My problem is that I dont know how to run Monarch. I have Monarch Model, a file with ....
I have a subform called MySubForm in a form called MyForm
MySubForm has a record source of query1
I want to change the record sorce of the subform without closing the form to query2 and ...
Hi All -
I have a MS Access database called Customers with several columns.
I created a windows form in Visual Studio using C# that adds and updates the records.
Two of the columns are a...
Can anyone tell me how to create a time field that does Hours, Minutes, and Seconds?
I have tried Short Time, but I lose the seconds. I tried Long Time, but it adds the AM/PM - and it also c...
I need to execute a stored procedure using VBA in my Access front end. The stored procedure:
CREATE PROCEDURE danhomp.spCreateRandomingView
@PubID varchar(...
I've created a windows package file through MS Access 2003 Packaging Wizard and when it is run on a client PC, the user gets the message:
"The system administrator has set policies to preve...
I have an Access 2007 app that uses sendobject to send an email message without displaying the message. I am wondering if there is any to envoke the Outlook Global Address Book Dialog box (o...
MY code from help on ee is
Undefined funtion "format" in expression. Maybe this is the cause of the form to report process failing
PARAMETERS [Enter Start Date] DateTime, [Enter End Date]...
I have three tables: Employee, Transaction, Locked_Obejct. Employee is related to Transaction by employee# and Locked_Object is related to Transaction by object#.
How do I create an entry for...
In a previous question, I requested the ability to concatenate fields in a group by query. I found out that I need to be able to concatenate only those entries in the field that are not alrea...
