Search results
-
A
Solved Vertical scrolling issues in a query design view
I cannot scroll vertically in a query design view. The verical scroll slider is at its topmost position and I cannot see the top of the tables - with table names. There is no property associated with table size or position to enable drag them down See screenshot below I dont know why this... -
A
Solved Using AND with month function in Dlookup - query expression
I have 2 tables with dates. Table and Field names are tblCustRMPriceMaster->Pricedate tblCustRFQ->RFQDate Table structure of tblCustRMPriceMaster is as below In a query, I want to build an expression wherein I fetch values of PP or HDPE matching the Endcustcode and month of the 2 date... -
A
Solved Using a Query and Table in form makes it uneditable
June7 This trail is old as I could not, for some reason, pursue this development and am now in the process to finalise this. The DB is enclosed. I am facing one issue for which I need help. I need to develop a form for the table tblCustFabricConvRates. The queries are in place and working... -
A
Updating table data using Excel
I never got around to do this and ultimately had to do it manually. Fortunately the update was needed in about 200 of the 1000+ records which i narrowed down by filtering the data I have a much more complicated issue at hand now. I have a 'ItemMastertbl' where the PK is an autonumber. There... -
A
Adding system date in report file name
Arnel I finally got around to implementing it and after an initial hiccup, found the way to implement it. I really appreciate your effort Regards, Anil -
A
Solved date() - 1 as default value in a text box control
Thanks. I had the formulae in place. I did not realise that it would work only in new records. -
A
Solved date() - 1 as default value in a text box control
I would like the default value of a text box to display default date()-1 I tried following expressions in the default control source =Date()-1 =dateadd("d",-1,date()) Both don't work. I don't get an error, but the displayed date is always the date() Why don't these expressions work? -
A
Column header of Sr No in reports
I have created a report with Sr no. There is no column header for Sr no. The report is OK when I view it but on exporting to Excel, I get strange headers - see 3 screenshots enclosed. What is the reason and how to resolve this? -
A
Adding system date in report file name
WOW!! This is Super! Couple of queries. My queries may seem dumb as I dont really follow the code fully and will just paste them 1. The Public Function fncSerialFile and fncFilePath will have to be copied in the "OnClick" Event of each report button? Perhaps not. If not, where do I place it... -
A
Adding system date in report file name
I have a main form in the DB where I have several command buttons for reports. I save these Excel and PDF reports in a common folder as seen below Private Sub Command57_Click() DoCmd.OutputTo acOutputReport, "rptContainersInTransit", acFormatPDF, "C:\Access\ContainersTransit.pdf" End Sub... -
A
Refresh issues in cbo of Forms
@Gasman- thanks. corrected @GinaWhipp- DB enclosed. I have tried some other things like me.requery - does not help Forms in question InvHDrfrm2 and frmcontainerbooking -
A
Refresh issues in cbo of Forms
This is out of my depth Will try to post the DB with abridged data. Would appreciate if you could help me with the changes. I have started learning access only 4 months ago -
A
Refresh issues in cbo of Forms
Requery itself? Does not fetch any data - blank! I have another problem The source data of the cbo consigneecode is a qry. If I try to change the code i get an error as per C1 enclsoed and on debugging get an error as per C2 enclsoed! -
A
Refresh issues in cbo of Forms
I use requery on cbo names. The cbo name is "cboContainerNo" and the form name is "InvHdrfrm2". In this form, the row source for ContainerNo is "tblContainerBooking" and field name is ContaineNo, which is updated by 'frmContainerBooking'. T The QBE of cboContainerNo is as below The issue I... -
A
Refresh issues in cbo of Forms
I have an issue with refresh data in the main form/Subform section. The database is huge and in split form (FE and BE) hence sharing screenshots and not DB 1. The form in question is of Invoice entry - Main form and sub form. The issue pertains to the main form 2. I capture the consignee code... -
A
Report columns change on export to Excel
I have a report linked to a query. I changed the names of report headers with spaces eg "Customs Duty paid by" is the report column header where the field name is "CustomsDutyBy" When I export using the External Data Excel tab, the report header become field names! The option of export with... -
A
Export Access Query to Excel
I I have not tried it as I don't know how and where to use it! -
A
Export Access Query to Excel
What are the values ASP and ASP2 in the statement. I want to Export a query (say qryTest) to an excel sheet. What should be the command button code in the click event??