Search results
-
B
SYNTAX ERROR when INNER JOIN
Hi, I am having the following issue with the exact same SQL query Window7 + Access 2013: INNER JOIN query works without issues on SQL tables Windows 10 + Access 2016: exactly the same query: SYNTAX ERROR when INNER JOIN on SQL tables all other queries work fine. -
B
Change record source on a Form via Combobox
How do I change record source on a Form via Combobox? VBA:confused: What I have now: The user chooses Form1 from Combobox, Form1 opens with record source to Table1 The user chooses Form2 from Combobox, Form2 opens with record source to Table2 Form1, Form2, FormX are identical, the only... -
B
Problem when printing report
I have a report that I use for printing labels. The problem is the first row of labels are perfect but the second row and further the labels are moved by 1cm downwards, the second row is then moved 2cm...:eek: Any tips why the report does that? -
B
Reset imageBox on a form?
How do I reset a imagebox on a form? I use a command button to reset all the other fields but it doesn't work on a image box. The code: Private Sub rstFields_Click() Dim ctl As Control For Each ctl In Me.Controls Select Case ctl.ControlType Case acTextBox, acComboBox, acListBox, acCheckBox If... -
B
Image change based on combo box selection
Hi I have very simple database consisting of one table "tblMain" and one form "frmMain". On the form i have a two cascading combo boxes and two text box which get their data from combo boxes. The issue that I have is I am trying to add image to my form which is based on selection in a combo... -
B
How to print duplicates of one label?
Hi I have made a program for printing labels i access 2003 and now the only thing I have left is how to print multiple records of one label?. . I have a very simple database with one table, one form and one report. I would like to have a control box in the form for how many labels I want to...