I use MX and i have a form with a list (first Name). When I selec the list I want the other text field to put in the corresponding last name from the database in the field on the form...
I know I need to use an OnChange function but not sure exactly how to grab the second field from the...
See Text Manipulation post under Microsoft: Access other Topics. the last post was 4/10/2002.
If you need further explanation let me know. Scott Musich
Database Analyst/Programmer
Do you have licenses for excel? If so you could export/link the tables to an excel spreedsheet. Depending on the size of the database this could get messy though.
Other solution you get the solution pack/runtime version - not sure if they still have this for access or if this is exactly what...
Is there and error? Is it attached to a query/table? Is it based of search critera? Is the form opening but there is not data?
A couple thing I can think of since it is not the properties.
I have a form that displays blank when it does not find any subsequent data from some sort of...
It sound like you have it right - just to make sure, the [Enter Year: ] must be typed in exactly the same in all subreport queries/sql and textbox!
Does it ask you for year for EVERY subreport or just some of them - if it is just some of them then the above is probably true. Scott Musich...
Try something like the following - I know it looks like a mess but here it goes - I did this in a query and used the Mid and InStr functions.
Mid([IP],InStr(InStr(1,[IP],".")+1,[IP],".")+1,3)
Breaking it apart:
What this does is searches for the 1st position where there is...
When you start the import click on Advanced (in the Import Text Wizard). Then change the field delimiter to the pipe. This should do it! Scott Musich
Database Analyst/Programmer
I have a few questions:
Are the remote users changing data frequently or just viewing the data? How important is it to have "Live" data?
I ask these questions becuase you could create a download process that will run and import/export new data each day (week, etc..) - you may have...
Before the main part of your code add the following (Access 97 syntax):
DoCmd.SetWarnings False
Make sure after the code to set it back to True otherwise nothing will pop up from that point forward until Access is closed down. Scott Musich
Database Analyst/Programmer
Thanks, This is what I ended up doing:
DoCmd.SetWarnings False
DoCmd.OpenQuery ("appendQry")
DoCmd.Requery
[Forms]![mainform]![subform2].Form.Requery
DoCmd.SetWarnings True
The first requery refreshes subform1 and the second one does subform2 - for some reason refresh...
Great idea - it works great - can't beleive I didn't do that in the first place! However, how do I requery subform2 properly after clicking on subform1. Scott Musich
Database Analyst/Programmer
1) Yes, The selection in subform1 should be entered in subform2
2)They are related by the field that is being selected (LicenseID)
3) No - only one of them are - the Subform1 is actually a listing of possible data to be entered in (needs to be seperate - not combo box) - I am starting to...
I will try and explain as best as I can!
I have a form (MainFrm) with two subforms (subform1 and subform2). When I click on a record in subform1 I want a record to be added to subform2. (not actual names!)
I can get the needed data over to subform2 (to whatever record is selected). However I...
It't been a while since I used Paradox but doesn't paradox have an export feature? If so, export it out in text format and then import it into Access with the text format.
If you work at a place I use to, sometimes getting the necessary disk to do this from your tech dept. takes longer than...
I hope I understand fully your issue.
When you are asking for date (or anything else) - if it is named the exact same way in a report as the query it will display correctly and only ask you once!
Example
In query your criteris is "Between [Start Date] and [End Date]"
Then in the...
Depending what the security is on the database you can have the user just hit F11 to popup a hidden database window. Or hold Shift as the database open in Access. Not sure how you have it setup, but these are the simple solutions. Scott Musich
Database Analyst/Programmer
in the design/properties of the sub forms make sure Record Selectors is set to NO, Same as Navigation buttons! Scott Musich
Database Analyst/Programmer
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.