Search results

As the box is locked, would I need to populate it with some VBA code first ?

So, what's the best way to go about this then? Using the onchange event of the control box to trigger a database update, which I can do through VBA code maybe ? Any of the other events better then onchange, which may do it for every character that is typed ?

bump......

? ........

The query uses joins - would that affect it ?

The data is also exported as text. Excel has loads of green flags indicating the data is text instead of numeric. Any ideas?

Allow Filters Yes Allow Edits Yes Allow Deletions Yes Allow Additions Yes Data entry Yes Recordset type Dynaset Record Locks No locks Fetch defaults Yes

However, with a web page, the footer would automatically be put right at the bottom after all the Detail. In this form, the only part you can scroll through is the Detail section. The footer is at the bottom of the viewable screen and there doesn't seem to be a way to dynamically change the...

Locked is No Enabled is Yes Can't see anything on the form properties but might be missing something. None of the control boxes are editable so it's as though they're not linked to the data somehow. All values in the textboxes have come from a query.

Hi I have a form, which displays data from a query recordsource. One of the textboxes is a "Comments" textbox, which I would like the user to write in directly, which in turn is a direct link to the data in the table so it is updated immediately. At the moment, the textbox does not seem to be...

I have the following expression, which needs to be wrapped by some extra logic: IIf([NetTotal]<>0,IIf([NetTotal]-[InvoicesRaised]>0,30,[InvoicesRaised]/[NetTotal]*30),0) What I need to do is, if the above expression comes to less than 0, then the control box needs to display 0, otherwise it...

I have a standard form with header, detail, and footer sections. The detail section has a range of calculated boxes and the footer section also has a range of calculated control boxes. There is a button on the form, which runs the following code: DoCmd.OutputTo acOutputForm, "Divisions"...

Thanks. So, you pretty much have to do it with VBA code? There's no way to pass parameters to queries in Access as you would with stored procdures in SQL server?

This doesn't seem to allow any rom for expanding the form size when the Detail section has lots of data in it? A lot of users might be confused by the scroll bar, which only moves the Detail section. Are there any other ways round it ?

I have some reports which lay my data out perfectly. For example, Report header Page header Details Page footer Report footer Now, I'd like to have exactly the same layout on some forms but with various buttons, etc. for manipulating data. The only problem is that when I put something on the...

The biggest problem I have is that I cannot seem to get the headers of subreport 1 as well as the headers of subreport 2. Report 1 is Header Detail Footer (with calculated boxes in the footer) Report 2 is Header Detail I need to combine these into 1 main report so it looks seamless to the...

I come from a SQL Server background and am very familiar with store dprocedures and input parameteres. Is there a way to use a similar method in Access. or example, passing parameters from a button on a form to a query, which can change depending on the input parameter? If so, how ? Also, how...

I have a form where a user can press a button, which then prints a report. The report is basically the same as the form but laid out neater and in a format that fits it to 1 A4 page. For one of these reports, I would like it to run a different query depending upon which form is used. I know with...

Hi I have 2 reports, which retrieve data from different tables and have various calculated fields. I need to put both of these reports onto 1 main report so that users can print them directly and the layout is displayed neatly with all relevant information. Is this possible? I have been...

I know that in crystal reports, there is an "Export to Accss" button, which conveniently exports all data from the report. Is there a similar function for Access reports ?