Search results

That stopped it from opening. I will have to check it for a record with data. I will have to do that in the morning. Thanks.

I keep getting the OpenReport was cancelled message. I've tried this in the report: ***Start of Code*** Private Sub Report_NoData(Cancel As Integer) MsgBox "No data found! Closing report." Cancel = True End Sub ***End of Code And this: ***Start of Code*** Private Sub Report_NoData(Cancel...

I use the following code to close a form and open a selected report: *** Start of Code *** Application.Echo False, "" DoCmd.SetWarnings False DoCmd.Hourglass True DoCmd.OpenQuery "qryLevyBilledHoldDel" DoCmd.OpenQuery "qryUnpaidLevy" DoCmd.OpenQuery "qryUnpaidWaiver" DoCmd.OpenReport...

I have a database that users will be adding hyperlinks to. First, they will add the documents to a directory. Next, they will open the database to connect this to the appropriate record. They will open a form where they will type in a description in a text field. Then, they have a hyperlink...

Solved. I used a Select query behind the form I used to edit the field. It was connected directly to the actual record. When the change was made it was directly to the record. I can do this here because the record belongs to one person only and only that person would be in the record. No...

I manually cleaned up the "long text" field and tried it again and I had the same result. So, I went into DB2 and copied the text from that field. I then opened DB1 and used the process for adding a new record to that person's records. I pasted that data into the field in that record. I got the...

DB1 is an Access db with a SQL back-end. I have databases that go out into the field with some of the team. Here is how it works. Data is exported from DB1 into DB2. DB2 has more data added to it. DB2 appends data to DB3, a holding db. DB3 is linked to DB1. When DB3 has a record and DB1...

That is what I meant to say. I want to store the link in a table. First, how do I do that? Secondly, can I pull that link into another table by querying the student record with a link to this table? Thanks.

I have an MS Access front-end and a SQL back-end for a student database. I have no control over the SQL. I am going to be storing images on a shared drive. Here is what I would like to do. Store the attachments in an Access table. Add a field to that table with the studentid to identify the...

Ranman, I changed it to the code below and it worked. Thanks very much. SELECT tblParts.Part, tblParts.Category, Format([tblParts].[SellingPrice],"Currency") AS Price, tblParts.PartID FROM tblParts ORDER BY tblParts.Part;

Ranman, I used SQL and it worked. Here is what I used: SELECT tblParts.Part, tblParts.Category, Format(tblParts.SellingPrice,"$0,000.00") AS Price, tblParts.PartID FROM tblParts ORDER BY tblParts.Part; This gives me a leading 0 ($0,325.56). I tried to get rid of it but can't. What do I...

I will try to do it in SQL and get back with you tomorrow. Thanks.

Cute, but not helpful.

Ranman, I did that and it didn't work. Also, to the others, I used an Access query, not SQL.

I have a combo box using the PartID as the datasource of the field. I use a query as the Row Source. Based on the PartID selected, the dropdown list will display the Part, the Part Category, and the Selling Price. The Selling Price in the original table is formatted as a Double, Standard, 2...

I did some back tracking and was able to get the [Printed] field coming into the database as a General Date, which gives me the date and time. The expression now works. Thanks.

I used this to get my expression. What did I miss? http://allenbrowne.com/casu-13.html Calculating elapsed time How do you calculate the difference between two date/time fields, such as the hours worked between clock-on and clock-off? Use DateDiff() to calculate the elapsed time. It returns...

That is where I got my help. Use DateDiff() to calculate the elapsed time. It returns whole numbers only, so if you want hours and fractions of an hour, you must work in minutes. If you want minutes and seconds, you must get the difference in seconds. Let's assume a date/time field named...

How should that expression look then?

[Printed] is a Date/Time field formatted as Short Time. Default is Time()