Search results

BobLarson - you are wonderful THANK YOU so very very much I can't thank everyone enough for taking the time to help those if us in need Rick

Thanks The_Doc_Man I will read up I appreciate your help and comments Rick

On my form I have 2 radio buttons rdoAll and rdoSpecific. If rdoAll is true then it prints a report. THis part works fine. However if rdoSpecific is true then I make visable combo box to look up an ID. Then when I click the button I want the same form to open but with just the info pertaining to...

Thanks for your honesty that is exactly what I needed to know. Not what I wanted to hear but what I needed to know. Any suggestions on how to handle my issue. I need to be able to choose a product (or all my products) and report their current stage via report or query. I'm open to suggestions...

In my db I am tracking different stages for an event. I have a subform that is in datasheet view. The last field (current) is a yes/no check box that says that this entry is the current stage of the process. In one of the fields I have a afterupdate event that says me.current = true. But what I...

Yea that address thing bothered me too but I was having a hard time trying to come up with a better idea. I just wanted to be able to track for families, single moms/dads, divorced familes, mom and grandma all those possibilities. Maybe I should scrap the whole thing and go back to the design...

Bat17 - I have the query that I'm running (qryAll and/or qryEverything) containg every possible field (I think). And each field is on one of the tabs somewhere (I think). LIke I said I have been mwssign with this for 3 days and I have tried so many different options and ways and now everyting is...

Can someone help me out by looking at my database I've been messing with it for 3 days and I can't figure it out. I have 4 tables each are in a 1 to 1 relationship. From there I have a query that is for every field between the 4 tables. I then have a Tab Control form with 4 tabs and it uses the...

I suold let you know at this point it's written in access 97

I'm not sure what you mean by..Can you insert the sub-forms with the query wizard enabled?

Tab Control with Subforms / "Can't build a link between unbound forms" error I am trying to create a database for a cub scout pack that just keeps scouts information, medical info, parents info, and parents medical info each is a seperate table. I have created a Tab controlled form with 4 tabs...

boblarson, Thanks for the reply, I did make it an mde and that didn't let me conver it but I would prefer to not get that far. I'd like so when I click on Library.mdb(mde) it checks and if it isn't access 97 maybe a messabe box pops up and says "Can't use with this version of access" or...

My database is written in Access 97 (I know get out of the stone age) but we have a mix of office 97 and office 2003 users. Anyway I'm afraid that one of the few people that have access 2000 or higher will open my database and convert it. I found (through here) code to check the version but it...

I have a library database that I want to delete a record in my tblStatus when the book is returned. I have found the deleteobject function but it appears that that will delete like a table or query or report or something like that. I have no need to keep track of how many times a certain book...

I've spent about an hour searching this site for email issues but most I found we how to send. I want to take existing data and make an email address. I have a FName field and an LName field. In my email field I want FName.LName@email.com. the @email.com will always be the ending. Also where...

I have the same question. I have a FName field and an LName field and I want to take the FName data put in a . (period) then the LName data with the static @email.com Thanks, Rick

I have a library database that I have scanned book covers into. In Access 97 I have a Bound Object Frame that I display the image in. I am in the process of redesigning the database and am playing with SQL. I have exported all of the information and imported it into SQL but my images aren't...

After playing around a little more I guess I have only gotten 1/2 of my format issue fixed. I'm trying to get it to sort on the last name and then on a contact date. The last name is working correctly and in the grouping section I added my cdate as the second grouping (after lname) but my report...

That's it THANK YOU VERY MUCH!! Rick

I don't think I have any groupings and I probably should have mentioned this is access 97. Where do I find groupings? What kind of image do you want?