Search results

Any help would be greatly appreciated. I am trying to open a report (rptGMX-IRG) that includes a sub-report (srptRG) based on criteria that is set with two unbound fields on a form (frmGMXbook). This form has two dropdown boxes (cboGMX_No & cboMachSize) and a command button. The first...

Hello. I was reading a post about a PM database you were writing. I was wondering if you would be willing to share it with me. I am starting from scratch and would appreciate a copy if could provide me with a template of yours.

gblack: Yes, thanks. I realized this not long after I sent the post. I have placed it in the "OnChange" event and I added a close button as suggested. Thanks

Hello. I am hoping someone can help me with this. My Situation: I have 2 combo boxes on a form. The 2nd box is not visible unless the 1st box is set to a specific value (Illness). Once the specific value is set, the 2nd box appears with appropriate data for selection. :banghead: Goal #1: I...

Thanks for your replies. I am going to rewrite the queries and split the fields. After thinking about it and reading Mark's reply, I have come to the conclusion to fix it now and not Band-Aid it. This way, as I grow it (having more knowledge now) I can do it the right way. Thanks for your...

:banghead: I wrote a database several years ago and recently pulled it out to give to a friend. The problem is, back then (not knowing better) I set the Employee table up with as a single field "NAME". Now, in order to make it effective, I need the Employee's name in four (4) parts (First...

No. The first section could be ABC or DEFG. The second could be 10, 20, 120, 130

Below is what I have in my table in field ArborID. I am trying to get a field in my query that would show what is depicted in the second group below. ArborID ABC-10-BC-KIN-01 ABC-20-AC-KIN-01 ABC-25-AC-KIN-01 ABC-25-AC-KIN-02 DEF-40-BC-KIN-01 ArborID ABC-10 ABC-20 ABC-25 DEF-40 (* Notice the...

Same error on " int_FirstDash = " line.

I am getting a "Variable Not Defined" on ret = "Error" line.

Okay. Thank you. I'll try to build a function but haven't done one for something like this. If you have any examples or know where I can look I would appreciate it. Thanks again.

How is that one too much when I get this to work perfectly. MaterialCode: IIf(Left([Description_5],1)="8",(Mid([Description_5],InStr([Description_5],"-")+1,(InStr(InStr([Description_5],"-")+1,[Description_5],".")-InStr([Description_5],"-"))-1)),999)

Trying to parse first two sections of a five section string. Now getting a SYNTAX COMMA ERROR. Can someone take a look and tell me what's wrong. I've looked at it TOO long. Thanks...

:banghead: I have a form that shows details of a record. I have a command button to open associated records in another form in DS view. My code will open the DS and show all records or filtered to specific record. What I would like to do is use code on command button to open DS view and simply...

Yes, it was open. I have went a different route and got what I needed. Thanks

I am trying to generate a report that is based off of a query. The query has a form filter that it needs to filter the data. I keep getting a jet engine error and couple others. The form has year, start week, and end week on it. I can get the query to work fine. When I try to open the report...

Pbaldy & Cronk, Thanks guys. I appreciate your help. I have a good amount of computer experience in many different areas. In my past, I have always had a "programmer" that I could rely on and give him/her projects. I am now with a company that doesn't have one and I'm kind of becoming the...

Awesome. Thanks very much I'll try tomorrow.

I'm trying to go another route with a form as a filter. Now I'm having trouble getting that code to read all records if field is null.

The db is too large. What else would you like to see?