Search results

The code you posted is working it is printing the report to the printer without preview or epening the report. But I need to open the report not sent it to print. That is why I create "Open Report" button but it does not work made with the wizard.

I have a db see attached file that i need to be able to see how many items are left unsold in a form that I use to sell items. See form: sell madef rom sell Query On theform see textbox Stock Live - it should show how many items are left. This is the problem I need to solve. I have 2 tables...

Tried your code but the line I place in my query: NewField: FormatFields("[YourField]", "[YourTable]", "[YourPrimaryKey] = " & [YourPrimaryKey], 3, 10) Gives me an error: expression contains invalid syntax. Perhaps you omitted comman or something.

No I did not delete anything, this is default code from wizard. Weird but perhaps access 2007 has bug or something?

I'm still here :) I need a code that would take records from a query like: Record 1 Record 2 Record 3 and so on.... Than make that they would look in my first query across then down, in my second query down, then across. I have 2 queries I must use in my report, I could use subreports but...

Default printer: Canon Pixma 6600D, Open reprot button - that does not work Private Sub Command0_Click() On Error GoTo Err_Command0_Click stDocName = "___pagrindinis_pvm" Exit_Command0_Click: Exit Sub Err_Command0_Click: MsgBox Err.Description Resume...

No it nor doing anything, and not printing that is for sure. I would see canon printer popup that would show my document is printing. I have added my database path to trusted location etc. Please help.

I use access 2007 designed blank form and added command button, then selected report operation -> open report selected my report. When I open the form and click the button nothing happens however if I add preview report it works why?

While I tried the subreport column mode I ran into a problem with subreports headers being not shown. I found a fix here http://209.85.135.104/search?q=cache:n962pxISMAsJ:thepoorhouse.org.uk/faking_page_headers_on_a_microsoft_access_subreport+access+subreport+header&hl=lt&ct=clnk&cd=2&gl=lt...

Perhaps someone can modify the code here http://support.microsoft.com/Default.aspx?id=210236 To increment the data by one ?

Moniker has provided you with basically the simple answer you need. Yes he did, but I asked for a VBA solution not subreport. Where does it say anything about a SubReport? In my post it doesn't because I don't want to use subreport to format the data in columns. If you did not know if you use...

Thanks for your help, but I have problem: If I enter some records and number is incremented by one like 100 101 102 103 104 Then if I delete some record like "104" Next record is entered like 105 106 etc. But I need to check what is the last record and enter new incremented by 1, that...

Can't I somehow pull data using query and them merge the results separated by "," or ";". Then I would put unbound box on report page and some code and it would display data that I need?

Thanks for your suggestion, I found this http://support.microsoft.com/default.aspx?scid=kb;en-us;141624 It looks like not very complicated however I was unable to replicate this. Your subreport method sounds fine too but works only for across then down, not down then across listing. I need to...

I don't know any VBA so I need your help. I need a module that would output data to a report in columns instead of rows. When you make a report data is output like this: Title ------------------------------------------ record1 record2 record3 record4 record5 I need a module that would output...

Well then how do I make when I add new record it is duplicated from previous record and incremented by one? Also automatically enter todays date.

This was for invoice, and can require more than one page sometime.

Well it does not work for me "as standard". The Report footer is moved as close to detail section as possible. And if there are only few records I need it to be in the same place like I have 7 in example above. If I try to increase detail section size in design view it increases space above and...

I have a report that I need to keep Detail section fixed size, when there is enough data to fill it eccess should make page 2 then page 3 etc. In other words I have full report here with as much records as can fit on 1 page. If I lave less records I need to make it look like this Notice...

I got it working with =IIf([Text62] Is Not Null;"Pending")