Search results

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...

I'm currently using DoCmd.SendObject acSendReport, "rptInvoice", acFormatSNP, stemail, , , "OrderId ID# " & txtorderNo, strBody How can I manage to have the name of the attachment should be the orderNo, not the default report name? Thank you Joe

I used the VLOOKUP in excel. I would like to use the same idea in Access. Table 1 = MyFirstTable Field1 = ItmeName Field2 = Quantity Table 2 = MySecondTable Field1 = ItmeName Field2 = Quantity I have a query name qMyFirstTable I would like to add a column in this query that looks in...

I’m trying to ling access to a table in Informix/Unix and I got this error “The operation failed. There are too many indexes on table xyz_Informix Delete some of the indexes on the table and try the operation again” This is the only table I’m bringing in to access. I do not want to use any of...

I have an MsAccess DB with about 20 tables. I’m using this for about 2 years. The number of records is growing very fast. I was recommended to upgrade the DB to SQL. So I have played with the Northwind SQL sample DB. My understanding is that I can still keep all my forms/report in Access and...

I have a report with 5 fields on the detail section. Now I’m adding a 6th field bellow field 1. (This will be a two row report). When I’m exporting this to excel, field 6 is appearing after field 5 (On the same row) Is it possible to have field 6 be on a new row, so it can be a 2 row report in...