Recent content by myhnews

Wow. Very interesting experience. The issue was that the invoice number field was linked to an other table, Which didn't allow update. But I'm wondering why I didn't get error. Thanks for your help and sorry.

This is what i have . i onlt pasted a part of it. my issue is that it doesnt update the records. i get no error. I realized that the tables are only linked to my front end. Is that the issue? If yes, what line do I need to change? The backend DB is at C:\ Databse\programBE

This is the code I have. I tried many times, and it didn’t update. I just realized that the tables are only linked to my front end. Is that the issue? If yes, what line do I need to change? The backend DB is at C:\ Databse\programBE Dim db As DAO.Database Dim rs As...

I have spent lot of time to figure this out. I would very appropriate if you can put the full code the I need to have. I'm not gigs on this. I already have code to export. I only need code to update field. Thanks

I would like to export selected records (from list box) to .xls file, also populate the same value to all selected records. The value will be entered on the form once. I'm attaching a small sample DB, so you can see what I have so far. Any help is appreciated, the Export function, or the...

Attached is the DB. Thanks for your help.

The answer to all questions is YES

Main query: --------------- SELECT tblOrder.TitleCoID, tblClients.TitleCoName, tblOrder.HandledBy, tblOrder.TitleNo, tblListOrderType.Type, tblOrder.RequestDate, tblOrder.Price, tblOrder.InternalID, Format([RequestDate],"yyyy/mm") AS ReqDate FROM tblListOrderType RIGHT JOIN (tblClients RIGHT...

Sorry, I haven’t created it yet, but I plan to make ListBox control, select multiple records, then exports the selected records to excel. Thanks

I'm selecting multiple records from a list, now I would like to export these selected records to excel. How do I do this? Thanks

Where is the best place to add this Dim intTotalPages As Integer Dim strMsg As String intTotalPages = Me.[Pages] strMsg = "This report contains " & intTotalPages & " pages." If intTotalPages > 1 Then MsgBox strMsg End If at the on load or at onPage etc? Thanks

DCount should work. can you please give me a basic sample of DCount to count the records in the subreport? Thanks

Is there a way to hide a label on a report if the sub report count is 0? Thanks

On July 2008 I lost the joins/relationships between many tables as well as some primary keys? This allowed the user to enter the same value in the primary key field. I manually removed all duplications and fixed all relationships and primary keys. Recently the users called me again that they...

I’m currently using a function (that is executed with a click of a button) that selects a report and converts it to a .snp format. Then, it creates a new email and attaches the snapshot file without saving the file in a temp table. However, not all my customers has snapshot viewer installed. So...