Search results

playing video games

Here is a date picker tutorial http://www.fontstuff.com/access/acctut09.htm

Galaxiom, I have been chastised and am repentant on this issue. :( I will no longer attempt to format numbers as text except in dire circumstances. :) Perhaps only life or death. Please forgive me. Alan

I should have added earlier, that this generally happens when importing spreadsheet data for manipulation and then exporting back out to Excel. Further, it generally happens when importing data that requires preservation of preceding zeros to maintain continuity. Again, in every case that I...

where he received

I am referring to things such as values that really will never require or be required to be calculated. Perhaps an invoice number. It is not often and really depends on how the data will be employed. Bills of Lading, part numbers.

Assuming you have values in Column A and using that as your determinent for the last row, this should work for you Sub Insert() Dim x As Integer Dim i As Integer Dim total As Integer x = Range("A" & Rows.Count).End(xlUp).Row total = 1 i = i + 1 Sheets(1).Range("G3").Value = total...

City Aquarium auditorium

Further to Frothingslosh's explanation http://ss64.com/access/acspreadsheettype.html

What does this mean? I don't understand. I usually make fields text (even if numerical looking) unless they require calculations to be performed on them. If that is the case, then I format the fields as numerical or dates as the case may require.

If you are looking for a log of who entered/updated records, then look at this link. http://www.datawright.com.au/access_resources/tracking_data_changes_in_access.htm Alan

change the DoCmd.TransferSpreadsheet line as below DoCmd.TransferSpreadsheet acExport, 10, "All_Items_1", curPath, -1 and this should export an .xlsx as you wish. Look at this link http://msdn.microsoft.com/en-us/library/office/bb225982(v=office.12).aspx

Post your VBA code for the export. I had some similar issues when I first ugraded that required a small change in the VBA when I used the DoCmd.TransferSpreadsheet.

a welding shield

seductive and charming

Still don't know what the issue is with opening the example. Below is code for two queries in an option frame. Depending on which one is selected by the user will determine which one is transferred to Excel Private Sub Command3_Click() Dim reportName As String Dim theFilePath As...

Did you look at the VBA in the example I posted? There is a complete example of the code for exporting a query to Excel. It is in Access 2007-2010 format. It opens ok for me. Alan

Look at the attached example

Run an update query triggered off the command button to change the value in the field.

The only way to overcome this is to choose a specific client and that means you cannot use the LIKE function. change this line Like "*" & [Forms].[frmLBT_db_Tool].[cmbName] & "*" to [Forms].[frmLBT_db_Tool].[cmbName] Of course, this means that your query will fail if the combo box for the...