Search results for query: *

I had this same problem recently. Even though this is an old request for help, I thought it might help someone Searching for help in the future. I resolved the problem with the help of Microsoft's Knowledge Base http://support.microsoft.com/default.aspx?SCID=kb;en-us;818954 Even though the...

Thank you bcastner yet again. In short, winxptutor.com pointed me to a Microsoft download page to help create the Win XP Setup Boot Disks (neccesary). I then followed the lavasoftsupport.com link: page 4 goes over the steps to correct the registry. - MSK

Thanks for reading this, but I found Dlookup and set the textboxes control to a Dlookup function. - MSK

I've got a form for showing/editing my database records. One of the fields is City. I have a table which has two fields - the long version of the city name and the short version (LongCity and ShortCity). The City field on my form correlates to the LongCity version. I'd like to add a textbox...

I have a similar situation but I can't set a button to the default as there are multiple buttons on the page. _Keydown and _Keypress seem to be too early as the field isn't updated by the time they fire. _Exit would work, but I don't want the search to start if the user just pressed Tab as...

Thanks. Followed your first few steps. Don't have any relationships established. It was actually easier than I thought because access changed surprisingly little when I changed the name of the KeyField to OldKeyField. Created KeyField as new autonumber field. Just really had to change the...

Despite Access telling us that once you convert an Autonumber from Increment to Random you can't go back, we converted to Random. Now we really want to go back. I'm not sure how. We have a bunch of code and forms/reports written, so I can't just start using a copy of the db because all the...

Lookin good. Let me know if you have the same problem that I did when mixing the record level access with the SQL commands. My problem was that sometimes not all the records wound up in the results table. - MSK

It is evaluating your line of code: Form_frmPersonnelData.Filter = "[PCN] = " & .Fields("PCN") and setting the filter equal to PCN = LB7 You need quotes around the LB7. Try: Form_frmPersonnelData.Filter = "[PCN] = '" & .Fields("PCN") & "'" That should set the filter equal to: and setting the...

Tom, It seems that the problem I was having may relate to the two different kinds of table manipulations I was making. I replaced the delete query with a record by record delete; to the extent you are using the code I provided, I thought you'd like to know. I replaced the opening and delete...

This usually happens when you are trying to refer to something that is out of scope. My guess is it happens when your form or report is trying to call something that is not in scope. Does it actually make it to the code? (Try setting a breakpoint.) What is LB7? - MSK

Yes, Liens is my raw data. I've changed the line of code that you included to refer to a query ("qPortfolio") so that I can run the query independently to check the results. Also will make it easier as I decide to make the query a little more complex (e.g. filtering). By the way, I should...

Oops. I realize that I commented incorrectly in the actualy copying part. I set the filter on the form so I can use the main table's index to pull up just the record that calculations should be done for. Please refer to the below Do While Loop section. Do While Not .EOF...

The button that I click for the report, runs the sub that clears out the databases old data and populates it with new database. My sub looks like this. Public Sub CycleLiens() Dim cnn As New ADODB.Connection Dim rstLiens As New ADODB.Recordset Dim rstPortValRes As New...

Tom, I have the same situation: database contains raw data that is used in moderately complicated number crunching; reports data is based on number crunch results. I'm not done figuring out the best way to implement this yet, but here's what I've got so far: Part of each record in my...

Thanks Duane. Actually all those numbers are determined by state statute and have not changed in decades. However, I would like to put the calculations in a separate module. It seems that when I put the function in a separate code module, I cannot access the database fields the way I do here...

Thanks again Steve. - Mark - MSK

I have functions in a report module and Access says it is not finding certain fields. The functions return #error without error trapping. The Err.Description is "Lien Database can't find the field 'OrigAmt' referred to in you expression." The report's control source includes all of the...

Sorry. Embarrassed to say that the Add2 code was IN THE WRONG REPORT'S MODULE!! OK, so Add2 gives the right answer (of course without prompting for a parameter), but... Can I do this without having two sets of functions (one for the form and another for the report)? Thanks. - MSK

I don't get it then. Where should the functions be? I've made sure the report has HasModule = Yes, yet the report prompts me for Parameter Value for Add2 (which is located in the Report's code module). It then puts #Name? in the report. Add2 has no parameters: Public Function Add2() As...