wlc04
Last Activity: Sep 2 '06, 12:33 AM
Joined: May 2 '06
Location: Winter Haven, FL
-
What do you mean by intersection table? -
Do you need to know the length of the string or the actual text?...Leave a comment:
-
The package wizard is part of the developer extensions for access 2003. Let's you package and mdb or mde as a standalone application (you can package the runtime version of 2003, so the user doesn't even have to have access installed)Leave a comment:
-
Thanks Ronald, but I got it figured out.Leave a comment:
-
Thanks, but I figured it out. :)Leave a comment:
-
report record source
I would like to be able to set the record source of a report programatically , but I am not having much luck. I have 2 queries which could be the source depending on other parameters in the program, so depending on these parameters I want to change the record source.
Any ideas? -
report record source
I would like to be able to set the record source of a report programatically , but I am not having much luck. I have 2 queries which could be the source depending on other parameters in the program, so depending on these parameters I want to change the record source.
Any ideas? -
MS Access Report Record Source
I would like to be able to set the record source of a report programatically , but I am not having much luck. I have 2 queries which could be the source depending on other parameters in the program, so depending on these parameters I want to change the record source.
Any ideas? -
If you manually export the data to a text file you are prompted for several parameters.
When you reach the last parameter (you will specify the export path) choose the Advanced button and then choose Save As and it will give you a default specification name (you can rename whatever you want). This specification is saved and can be used in macros and modules so that access knows how you want the file to look when it's exported.Leave a comment:
-
Using the updated version of access open the 97 version. Upon initial opening it will ask you if you want to open or convert it. Chose to convert it. Once the conversion is complete you should be fully functional.Leave a comment:
-
Private Sub btn_SearchTopic _Click()
On Error GoTo Err_btn_SearchT opic_Click
Dim Criteria As String
Dim MyRS As DAO.Recordset
' Find the record that matches the control
'load form2 to use its recordset, but don't show it
'DoCmd.OpenTabl e ("[Topic Information]")
DoCmd.OpenForm "Topic Information"
Forms![View All Topics].SetFocus
Forms![Topic Information].Visible...Leave a comment:
-
Do you have another form that you are calling it from?
docmd.openform "Edit Topic Information"
mainform.setfoc us
Forms![Edit Topic Information].Form.Visible = False
Another option is make the form you don't want to see a subform of your main form and just set it's visible property to false.Leave a comment:
-
When you export tables export specifications are created so that access knows how to handle the fields and what parameters you wish to use for delimeters, etc. How many table options do you have? You may need to create export specifications for each table. At this point there are different options to you have to for the user so they know what to choose from. Let me know how many tables you have and more specifically how you want to present this...Leave a comment:
-
You could try to export it to a delimited text file and use some vb code from excel to move the data into a "horizontal presentation".Leave a comment:
-
Do you have an export specification built?Leave a comment:
-
You could build other queries off of the first one where you have established the date range. In the second query don't add the date field and then use the group by option to narrow down the individual ids and types. You could build a third to get an actual count if that is what you want.
Another option is to build a report off of the main query and then use the grouping feature to seperate the individual ids/types with the date...Leave a comment:
-
When you get to screen 4 you can add additional files to be packaged. Click add and find the files you want.
NOTE: I don't know if there's a limit to the number that can be added.Leave a comment:
-
Are you using these calculations in a report like you stated in your original post?
If so, then you could have a header/footer for the section which lists the detail data for each shift, then put the calculation in the footer (without the identifier (iif([shift])="1" or "2" or "3"). At this point the calculation will be done for each section of the report.Leave a comment:
-
OOPS!! Sorry about missing the sum, but I'm glad you figured it out. :oLeave a comment:
-
Try this:
=sum(([QtyProduced]/([runtime]+[downtime]*[Piecesnum]))Leave a comment:
No activity results to display
Leave a comment: