Search results

Hi, basically i have a form for making new users on our system and at first I used the access default system for subforms, where the Primary Key field shows (New) until something is entered into another field in the form and it automatically then creates said new record. My problem is that...

Hi, In my project I use reports to build and print out letters, but someone noted that after generation there is no easy way to make changes to the report. I tried going into 'Layout' View but some of the code queries the database via SQL and going into layout mode breaks it. Is there another...

Hi, I call some functions from a report but this report seems to have an issue; It runs all functions in correct order, twice. Is there anyone who can tell me why it is doing this and how i can prevent it? The functions are public and are being called from a common module.

This issue has been resolved elsewhere, but thanks go to plog for his help and insight. I'm trying to run a query as a rowsource in a combo box as SELECT Table.[Field1], Sum(Table.Field2) AS Total_Sum FROM Table WHERE (((Table.[Field3])=[Number])); If I remove 'sum()' then the box shows the...

[SOLVED] Please help - Calling functions from reports This has now been resolved, thank you RainLover and MSAccessRookie! Hi, in a report I made a public function like "Public Function FuncName() As String" and in the function I have set FuncName to "1" as a test. Then in a text box in the...

Hey there, basically I have information being show by date in my report like this: Number - Name - information - 01/12/2011 Number - Name - information - 01/12/2011 Number - Name - information - 01/12/2011 Number - Name - information - 05/12/2011 Number - Name - information - 05/12/2011...

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

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

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

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