Search results

Hi, I'm trying to use a single report as a letter template. I have a subform datasheet of X amount of rows and Y amount of columns. I want to use the report as a template to create X reports using data in the sheet. Basically I want a report for each row using this 1 template. Is this...

SOLVED - Decimal points not saving in subform? ###### SOLVED ###### It turns out that that access didn't link the table properly and refreshing the list fixed this. With all these issues I keep coming across and fixing myself it might actually help someone. xD ############ I'm using an...

[SOLVED] Having trouble with Multiple Tables in 1 Report. ###### UPDATE ###### Figured it out, just used two sub-reports in the main report. Thanks anyway! ###### I'm having trouble querying two tables in one report. I have the actual query down (here it is). SELECT * FROM Table1, Table2...

Are the objects you are hiding always the same? If so, you could try creating one function to hide/show them and just call that every time you need it.

These subforms are driving me batty, My subform pulls information specific to an Account Number defined in: [SubFormName].Form.FilterOn = False [SubFormName].Form.Filter = "[Account Number] = " & AccountNumber & "" [SubFormName].Form.FilterOn = True [SubFormName].Form.Refresh...

It turns out that the issue was the DB import removed the 'auto-increment' status on my tables. Thank you for your help jdraw.

(SOLVED) Embedded subform crashes after adding 2 new records? --- UPDATE (SOLVED) --- My sincere apologies to anyone who read this wanted to help, it turns out during the import from Access DB to MySQL the Database lost it's 'auto-increment' status on all primary keys. This was my problem...

Yeah it was very hard to word; listID was a non-generated number that could not appear more than one, the list table itself is static, so you could theoretically treat listID as the primary key. But it doesn't matter now I found a little workaround. A better way to word my issue is basically, I...

How can I make some kind of subform combo box text mask? Hi, I'm having trouble with a specific issue in my database. Basically I have 2 tables, let's call them Subform and List, Subform exists basically to modify a table in a form, BUT one of the fields is a number called 'listID'. List has...