Recent content by businesshippieRH

spkiepl: Thank you. You're absolutely right. To answer some questions: We are a small environmental consulting firm. We deal with a lot of data, but nobody really manages it beyond the scope of a project at a time... Technically, I'm a biologist. I just have the strongest computer background...

I agree, a single table with rate schedules would be nice. Unfortunately, due to upper level decisions, each rate schedule must be its own table. My relations look something like the attached picture (drawn in excel for example). They are all tied together using PKs (*in image) in their...

I have a series of queries to get all of the information I'm looking for. Eventually, all of this information will go into a crosstab to show earnings across multiple jobs for each piece of equipment. However, I've hit a stumbling block. I need to be able to do a dlookup using a result from a...

WayneRyan, that worked perfectly. I simply moved it to the first statement. Also: sorry for the long delay, I've been out of town on a job and haven't been able to work on this project in a bit. Like I said, still learning my way through SQL, and the "As A, B, etc." is new to me. I'll...

Thanks. MarkK, your statement looks the same as mine (minus the fact that the code is easier to read due to line breaks). However, if I'm missing something, please let me know. Any input is great since I really have nobody else at work that's written more than a macro. That first SQL statement...

I have also tried: CurrentDb.Execute AddSQL instead of DoCmd.SetWarnings (WarningsOff) DoCmd.RunSQL AddSQL DoCmd.SetWarnings (WarningsOn) However, it throws RunTime Error 3061 (not enough parameters). Only the first SQL statement is printed to the intermediate window as the loop stops at...

I have created a loop which seems to work perfectly. The AddSQL bit prints perfectly to the intermediate window. However, the DoCmd.RunSQL doesn't seem to work, and I can't figure out why. Any help is appreciated! Private Sub Form_Load() 'Add all new entries from Default schedule to "temporary"...

Message deleted and moved to new thread.

I'm having a little trouble figuring something out, but I'm sure some of you experts can help. I have a table which is basically used to fill in a form (tbl_RateSchedule_NEW) and is spit back out as a new table. This part all works great and code isn't included below. The problem is, there's...

Duh... Thanks! This is what happens when you spend more time counting the spaces and commas than stepping back and looking at the whole thing.

I've looked over this bit of code so many times and have no idea what I'm missing... here's hoping a fresh pair of eyes'll catch it! 'BEFORE THIS IS A BUNCH OF STUFF TO MAKE SURE NONE OF THE VARIBLES ARE NULL 'Save Record to tbl_EquipmentList 'Set Up Strings Dim ID As Variant ID =...

Also: I got to thinking... is there anything else that would break code other than ' and " ? If not, I may just stick with the simple replace. Otherwise everything inside my string should be caught in between quotes for the string, right?... Ex: "blah blah * blah". = blah blah * blah Whereas...

I finally solved it. For those interested: I simply output the Finder to a table and base the rowsources on the created table at each control_Change or whatever was called for for that particular control. Code is as follows: 'Procedure for Setting Up "Finder" as Table 'Set up Finder for RS...

I've come across a slight problem and was wondering what approaches others have used to solve it... I have a Memo field that is used to be a description of a document. I don't know what the user will put in (could be anything), but it is eventually passed in a string to a query, etc. The...

It was pulling some odd stuff thanks to the double declarations. I've given them all individual names and now everything is hunky-dory.