Search results

Okay, I've never had a reason to do this before, but like everything else in life, there comes a time when you will need to learn something new (daily for me). I have code right now that runs correctly to allow selection of a parent, determine it's children, and then run through all of the...

Try This Instead of using .book use .sheets and assign it to your desired name or variable. I use: 'When creating a new worksheet .sheet(1).Name = strSheetName 'When looking for an existing worksheet For intSheetCount = 1 To .sheets.Count If .sheets(intSheetCount).Name =...

:( This would have been a really good thread to share if there were a resolution. I've got a loops through tables at the moment while looping through records to look for an update date. Now I'm working on looping through tables and looking through certain records to export to excel. I'm...

No Current Record? Okay...couldn't pass the mappingID back and I don't know why, so I did an: rst.AddNew rst.Fields("LocationID") = (LocationID) rst.Fields("URIC") = (URIC) rst.Fields("Justification") = (Justification)...

:confused: Hehe...I had a Do Until <> before I got the "too few parameters" error and made a lot of changes. Luckily I fixed the parameters error. ...GOES TO TRY CHANGING IT BACK... Okay.... I've changed it to: Now the only issue is getting that darn mapID to pass back to the MappingID...

Obviously I have don't something wrong because I'm not getting the number to increment. Doesn't Order By sort in ascending order? If so, then why does this note work and why is the value not being passed back to the form? If IsNull(LocationID) Then MsgBox "You must provide an Location...

Okay...here is the mess OKay this is what I have so far, but I'm going nuts debugging. The idea was as described above to loop through the tables finding records where the LocationID field matches ID2Replace, replacing it with ID4Replace and repeating this through all of the tables in...

New Approach Okay, I made a form for users to select from a textbox the LocationID to be replace (held in a IDToReplace variable) and also a text box for the LocationID that the incorrect one is being replaced by (held in a IDReplacement). I just validated that entries were provided for the...

Okay, my inital dataset really should have been scrubbed, but the system is up and running and now I've got to go back and fix some serious issues. I have a locationID in the TblLocation that is passed to the same field in all of my TblITAssets which of course have their own primary keys...

not sure what's wrong..... I appreciate the help you both have provided, but I'm still getting the same error....the expression is to complex to evaluate:( Well, I guess I'm going to have to find another way around it. I'll try it on another system first. If you all can think of anything...

Pat, Thanks for your help. I guess I should have explained that I get this error: The expression is types incorrectly, or it is too complex to be evaluated..... I'm pretty sure that it is types correctly....because both forms of the expression give me the same error (your short expression...

Okay....I'm usually pretty clear headed about figuring things out, but this has got me all tied up this morning:-o SELECT tblLeave.* FROM tblLeave WHERE ((([Enter Date Slection:]= tblLeave.Depart)OR(([Enter Date Slection:]>tblLeave.Depart))) OR (([Enter Date Slection:]=tblLeave.Return)or[Enter...

I don't know why I'm getting this error. maybe it's because I'm trying to do something last minute. I was just going to shut the warnings off in my Macro, but my brain is to foggy and I can't seem to remember how to get that to work. I thought I could just RunCode (DoCmd.SetWarnings = False)...

I posted the code..but I don't think any of you have seen it. I'm surprised how quickly it was bumped to the next page. I'm hoping that someone can help. This version will be released next week.

ARCHIVEOPTIONSFrm ________________________________ Private Sub ArchiveRecord_Click() 'Opens the form to prompt users to enter a justification for the archive DoCmd.OpenForm "JUSTIFYFrm", acNormal End Sub JUSTIFYFrm _________________________________ Private Sub NoSave_and_Close_Click()...

No offense...it's a nice looking logo, but I just doesn't seem to fit the page.....or the environment. I guess it just looks really out of place. I think something a little less angular would be nice.:rolleyes:

I've tried DoCmd.Close and that closes the application as well. There is nothing fancy. No DLookUp, nothing. I'm closing a Justification Form that lunachs from a Macro on the Archive form. But it is not set up as a Subform...the Macro opens the second form so that users can enter a...

I have a simple form where the user enters the Department which selects a list of account on file. The user enters the justification for archiving the selected file then uses a control button. The control button runs an SQL statement that appends the record to the ArchiveTbl and Deletes the...

The_Doc_Man Wow, that was great. I'd actually considered a lot of your point before, but I wasn't sure if they were considered poor practice, of if they were okay as long as they met by certain standards. You've helped to clear up many of my questions. I do have a primary table that contains...

I'm getting ready to head a pretty large database consolidation effort. I don't know much about data warehousing but I'm about to have to learn. Anyway, I have many many spreadsheets and databases that need to be consolidated to eliminate user redundancy. Many of the tables and spreadsheets...