Recent content by ScottMusich

Sorry - I am using ASP. I will look at your suggestion closer and try it out thanks Scott Musich Online Editor

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

Set the default view to datasheet instead, see if that works how you want. 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...

No problem! You can also acheive this by using Macros - However, I find it cleaner to use the code approach. Scott Musich Database Analyst/Programmer

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...