Search results

Thank you for all the replies and I appreciate the time you took to understand my problem but your answers are currently too advanced for me. This Access application was not developed by me so I don't know in detail how it works. I was hoping for a quick solution like something obvious I am...

SELECT DISTINCT BATCHSERIES.BATCHSERIESNO, STOCKTABLE.ITEMNAME, BATCHSERIES.BESKR1, BATCHSERIES.BESKR2, BATCHSERIES.BESKR3, BATCHSERIES.BESKR4, STOCKTABLE.ITEMNAME2UK, STOCKTABLE.ITEMNAME3UK, StockUnitConvert([STOCKUNIT]) AS Unit FROM BATCHSERIES INNER JOIN STOCKTABLE ON (BATCHSERIES.ITEMNUMBER...

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.

Thank you for all replies and patience with a noob :) One table would eventually grow and then run into performance issues. Correct? And I am somewhat reluctant to just have one table as it feels like "placing all your eggs in one basket" My solution was this: Private Sub Combo0_Click()...

Maybe I am in over my head here but it just should be straight forward to create one form which is used as "universal" form and then change the record source depending what the user chooses in the combobox. In theory... It seems like copy/paste of the forms and then changing names and...

I don't understand how implementing your code will change the record source of the form...

Main Form > One combobox that retrieves the list of values from table FormA > opens when selected in prevoius combox, record source is set via forms properties to TableA. A simple form with a couple of text fields.

Yes it makes sense, how do I do that with VBA? This is how the code looks like on click event of the combobox: Private Sub cmbMain_Click() ' combobox main form Select Case cmbMain Case "A" DoCmd.OpenForm "A" ' open form Case "B" DoCmd.OpenForm "B" Case...

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

I tried fiddling with all the margins, row spacings... and nothing helps. I thnik it is the marginal at the bottom that is the issue. If I set it to 0 it automatically changes that to 4,23mm as that it the bottom limit for the printer. The problem is the report somehow spiltes that per row so...

Yes after fiddling with it after a couple of hours I managed to get it down to a 2mm but the problem is still there. I uploaded a new DB but there are still many incorrections with the code but if you start the form and then choose from two comboboxes and then preview the report then you can...

No, the problem is still there. For every row labels move up for about 2mm

The size of the labels I use is 10,5cm W x 7,5cm H cm

I tried that still I have the same problem.

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?

Thanks! Works great now. :)

Can i somehow include that line in the code above?

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

Thanks! The DB works now as expected. :)

Well i took a look on the info you provided and I got the comboboxes working now. I have read the article about normalization but as novice to access it didn't help me that much so that could be something for another thread. Even though I copied much of the code from the flagsDB it still doesn't...