Search results

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

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

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

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

I have excel file with 15 sheets Is there a way that I can check if any of the fields are linked to another field or sheet (without checking each field)? Thank you

My main form has 2 “Continuous Forms” sub forms. The cycle of the sub forms is set to “All Records” Is there a way to exit the first sub form and move the focus to the second sub form utilizing only the keyboard? (Like shift + tab, or any custom buttons) I’m trying to avoid using the mouse...

How to I format a check box, to display on the report as Yes/No ? Thanks Joe

How to I format a check box, to display on the report as Yes/No ? Thanks Joe

I have a tblState, every state can have multiple Counties, and every County can have multiple Municipalities This should be a One to Many to Many, right???? However, several states might have the same County name In order to resolve this, should I add 2 primary Keys in the tblCounty???? If...

I have a main form that has 10 sub forms Each sub form’s record source is link to a different Query It takes more then a minute to open the form, (because it’s running the query for all sub forms) So I changed the sub forms source to SELECT * FROM tblTest WHERE false; I also changed the main...

I have a combo box on my main form. The Link child filed and Link master fields are configured correctly. I cannot figure out why the sub form does not get update after updating the combo box. (The combo box also uses a function, the function is running but the sub form does not get updated) I...

I have a one to many to many relationship; with the "Cascade update related fields", and "Cascade update related records" on the relationship properties checked. Since I have split the DB to FE and BE, the relationship properties (for the 3 tables on the FE) is grayed out and cannot be changed...

I am using DMax function for my custom autonumber I just realized that when using this in a multi user environment, I am getting duplications. This field is not the primary key, and I am using this as a group ID and cannot set it to “no duplications” My form also has a sub form, and when...