One thing you can do is put the deposit slip in the page footer and hide it if page number is greater than one. The only snag is the subsequent pages will have a blank area of the same size in the footer. (I tried varying the PageFooter height dynamically, but it doesn't seem to work).
This is the code assuming the Deposit Slip is a single label - if this is not the case you can enclose it in a group and make the group invisible in...
barry07
Last Activity: Sep 24 '07, 01:14 PM
Joined: Jan 19 '07
Location:
-
Presumambly there is a date field in each table that you use to determine which records are to be archived? If it has the same name in all tables then you can use the TableDef object to generate an Append and Delete query for each table.
If the date field is not named consistently you can still use this approach by identifying the TableDef field which has datatype = 8 (date). However, if there is more than one date field in the table...Leave a comment:
-
I'm guessing, but try Refresh or Requery - Repaint only reformats the screen it does nothing with data.
You may have to Requery/Refresh each combo box.
If that doesn't work can you post the RowSource for each combo box?Leave a comment:
-
Why? Why would you have two identical tables in the same database.
The actual code would be a deal more complex than what you suggest - you would either have to use a tableDef object or a MakeTable SQL statement with DoCmd.RunSQL.
Perhap if you tell us what you are trying to accomplish we could suggest a better solution.Leave a comment:
-
A quick and dirty solution - not necessarily the most elegant, but it works
1. Create a tabular report in Access from your query (use the wizard)
2. Open the report in Design View and insert a page break at the end of the detail section.
3. Save the report and check in Print Preview that you are getting the desired result
4. Export the Report to Word.
(In Access 2000 you do this from Tools>Office...Leave a comment:
-
You havent said what operating system you are using so this is something of a guess.
I imagine that durng the Form Load event the links between the front end and back end are set or refreshed.
I found with early versions of XP (i.e before SP2) that this process could be very slow. Worse, the links were refreshed every time the form was opened.
SP2 seemed to fix that.
Hope this helps.Leave a comment:
-
In a DSUM expression the syntax is
DSum("field","t able","criteria expression")
I can see it should be possible to use a user-defined function to generate the criteria expression, but using it to define the table name or field name seems to be pushing it a little.Leave a comment:
-
Sound to me like you need an Access form which will comprise the user interface and will connect to the tables in the background so look at the Access documentation about forms.
There is no possibility of running this on a machine that does not have access installed - unless you want to write a lot of VB code and do clever stuff with ODBC.
However you can compile your access database into an mde, which means all design features...Leave a comment:
-
Although you say empty Recordset I think you mean empty Record in which case I would use the Nz function which returns a specified value when the original value is null. It's one of the peculiarities of Access that I have discovered that nulls aren't always matched by expressions such as "isNull" or ="", or even IsEmpty.
This, however is a surefire method of detecting a null:
...Code:If Nz(rst2.Fields(0),"")
Leave a comment:
-
Error loading dll - any ideas?
I have an Access 2000 application which has been running successfully (on XP) for at least two years. One part of the application opens a word template and creates a report as a Word document. (Most of the Word code was written for me by a third party).
I had to reinstall Office 2000 (including Office 2000 Developer) recently and now when I try to run this prpcedure I get an "Error loading dll" message. The dll in question seems... -
Why on earth would you want to do that? And what happens when child3 comes along. Suggest you read the excellent artice on Database Normalistion before you go down this road.
You can generate Reports in the format you suggest if you need to, but that doesn't require that your data (Tables) are structured that way.Leave a comment:
-
I would try adding subform2 (the sub-sub form) as a subform on subform1. That way you can set up the correct parent/Child relationships.
Then add subform1 as a subform to the main form.
This is a bit of a guess but I think it should work.Leave a comment:
-
Use the ADO recordset. The syntax is something like this
...Code:Function CycleThroughRecords Dim dbs as Database Dim rs as Recordset set dbs=CurrentDB set rs=dbs.openRecordset("SELECT whatever from [table] where...") rs.movefirst while not rs.EOF .<manipulte records> rs.movenext wend set rs=nothing set dbs=nothing End FunctLeave a comment:
-
Daniel is correct that you don't need an event to hide the subreport. Just make the height of the subreport zero in design view and set CanGrow=Yes and CanShrink=Yes in the properties of the sub report.
However, you must also set CanGrow=Yes and CanShrink=Yes for the Report section which contains the subreport (|Detail, Report Footer or whatever)Leave a comment:
-
Hi Denburt,
If you can be sure that all your users will have access installed on their machines, then I agree the Developer's edition may not be worth the price. To me the fact that I can create a CD which installs my application plus access Run-Time on the user's machine makes it well worth the price. I've installed Runtime on over 50 sites - with up to 10 machines per site in some cases since 2000, so it has well and truly paid for itself....Leave a comment:
-
The VBA error handler which comes as an Add-In with MS Office 2k developer adds error handling automatically to your code procedures when invoked and it uses exactly the same syntax as in the original posting. The default is quite neat since it's easy to add handling routines for specific errors afterwards:
...Code:Function Whatever() On Error GoTo HandleErr .... do stuff .. ExitHere: Exit FunctionLeave a comment:
-
I hate to disagree with an expert of Mary's eminence, but I have successfully exported memo fields of up to 798 characters in length - I don't know what the prcatical limit is.
I use a slightly diffrerent syntax:
Code:DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, sQuery, sOutFile
Leave a comment:
-
barry07 replied to How to link ALL data with an specified PROJECT, create ACCOUNTS for users, and "EXE"in AccessHire a consultant or buy an off-the-shelf solution. This is NOT a job for a beginner. Coding errors or security breaches could easily cost your company ten times the development cost.Leave a comment:
-
Hi Stwange
I was not asking how to navigate records in table.
Once the records have been loaded onto a form (mine is a continous form), how would you navigate records on the form. I know there are navigate buttons but my requirement is to do something similar of my own.
WHY?Leave a comment:
-
You can set different margins for each report, and provided they are not outside the printer capability there should be no problem.
When you have the report open in Design View select File>Page Setup.
Set your margins and save the report. (Note you must EXPLICITLY save the report. If you just close it your settings may not be saved.)
If you know what printer your end-user is using it's worth installing that...Leave a comment:
No activity results to display
Leave a comment: