Recent content by PD1978US1

Not sure if this is correct in the FORM area. I have two different forms. Want to a particular button from one form to another form. The button has the same vba code. However, on the original form the button runs with the vba code, but if I copy the button to a different form with the same...

I have a query which displays "WEIGHT_VALUE" of a particular order in a column and the value is appended to a table later. Next to the column I have two columns called 'nr of cartons' and 'nr of pallets' Can I somehow have this table automatically adjusted to state the following: If weight is...

This is the complete script: Private Sub Command95_Click() DoCmd.SetWarnings False DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "Performance_report_HW_1_DE", CurrentProject.Path & "\Performance report HW-DE.xls", False, A3 DoCmd.TransferSpreadsheet acExport...

I have a database when I click on a button it transfers data from a table to an excel sheet which has two tabs. The original database and button works. Database is in the same folder as the excel file. Now I created a new database and copied the same vba string command and now it is telling...

yes..... when I change it back in the design view and run the query again it works. Somehow the initial query changes it beforehand, causing the issue.

Hi, Any idea why the Data Type changes automatically from Short Text -> Long Text for a particular field. Even if I change it back manually and save it over and over it still changes it back. Rgds, Daniel

Re: Query Issue - No Refresh of Existing Table Thanks. Just read into it. Just noticed that then I try to append the data it gives me a key violation error. I have a table with two primary keys. One being the order number and one the product number. key Violation error is based on duplicate...

HI, I have a query running which creates a table. It automatically refreshes / runs the query every 5mins. it adds new data, but it doesn't seem to update data as I have orders which are created with status "Normal", but still have the same status after being shipped. The status should turn...

I am a bit clueless. I understand where to put the expression but not how. I have 8x columns in the table and I presume I have to add something to ADDDATE and ACTUALSHIPDATE. The query gives me both adddate and actualshipdate... Do I have to take this over one to one: Select Field1, Field2...

Hi All, I have a Listbox and I would like to only display the orders which have been created and shipped on the current date (sysdate). In the table / query I have the ship date and time in one column. Is there a way I can alter the properties of the Listbox to only take orders which were...

yeah, have two monitors connected to my workstation....

Hi, see if this works: htt ps://drive.google.com/open?id=1lMQTqxiqR2R-JjeL6GCmfz74R1Gp0g-r I just tried the file on a different users pc.... there no issues...... Like I mentioned....if I start the database and hit F11 for the navigation pane and scroll left to right, the alignment of the...

Hey Minty, can you send me your email address via PM. The I'll send you some examples in the morning. Rgds, Daniel

Hi All, question. when working in the design window of a particular form I can align all text boxes and buttons to look good. However once I open the form, the alignment is not correct any more. Also when I move the navigation pane left to right and right to left the alignment also is...

is it possible to click on a button in the form, enter a reference number and this then generates the report from Access 2013 as an attachment in outlook opening the mail with the file? PDF perhaps?