Search results

Thanks......got the query to run, but I don't think I asked for what I'm really wanting. Now I have...... strMyPermissions = "Select permissions from Security where LoginID = kreiss" That part seems to be working.......What I really wanted is to store the permissions field into...

Thanks for the reply!........I'm getting a "Syntax error" Any suggestions? Thanks in advance, Kacy ________ LovelyWendie99

I have a permissions table that "1" is inquire, "2" is update and "3" is delete in the "Permissions" field. Not for sure how to do this, but thought it would be something like this as far as setting a variable for the users permissions strMyPermissions = "Select permissions from Security...

Is ther an easy way to clear a form? Currently I use the "DoCmd.GoToRecord , , acNewRec", but periodically I get I"m at the end of a recordset error which I would like to eliminate..... Thanks in advance, Kacy ________ Kitchen Measures

Is there away to shut off the Menu bar? Also I would like the navigation bar at the bottom to disappear (exp...the "1 of 3 records") Thanks in advance, Kacy ________ Plymouth Gtx

How do I get the textboxes and subform to be blank upon opening? When I open the form it always defaults to the first record. Thanks in advance, Kacy ________ Vaporite replacement parts

Is there anyway to view a macro that has been created in VBA. I'm writting a little in VBA and want to know how to write the code the same way the macro runs. Thanks in advance, Kacy ________ Lamborghini cheetah specifications

Thank you.........that works! Kacy ________ WEED VAPORIZERS

Ok, I tried a Union query and it works except it gives me a count for the same USERNAME from the APPOINTMENTS table and ARCHIVED table. I would like for them to be grouped by USERNAME regardless of which table they came from. Am I doing something wrong. I was able to run another sum query off...

I have two tables.......APPOINTMENT and ARCHIVED. I'm trying to get stats on how many appointments each username has scheduled. So I'm wanting to query both tables and group by "username" and get a count for each username Is this possible to do with one query. Sample table layout...

Thanks Wayne. ________ Lovely Wendie99

I'm still getting a compile error. I can live without this part however. I don't want you to have to spend anymore time on this. Thank you very much for your help. Kacy ________ Kitchen Measures

I have a user that has been making appointments, but no other users are able to see the appointments he has been making. I checked his icon and his database is sitting on his C drive. So I checked the network folder where the database SHOULD be located and that folder was gone. Well, now I...

Thanks guys.......on Nouba's db example I keep getting a compile error and can't figure out why. Any ideas? Kacy ________ THE APPRENTICE ADVICE

I tried that early and it didn't work, but I just ran across something that said Unions by default include distinct and to use the "union all" predicate. Got it working. Thanks, Kacy ________ Cheap acrylic bongs

I have six columns that have numbers in them. I would now like to combine this columns into one so I can have a report that groups the numbers together and gives me a count. Example of my columns col 1 col2 col3.....etc 5 6 5 3 5 6 So I could get an...

That's what I'm trying to ask anyways. So for example, my number in the above post, 99-569-78[00] I would like to have 99 in one field, 569 in one filed, 78 in one field and the 00 in one field. I was hoping in the query giving to me I could substitute some how the "-" for a "[" to...

This is great guys.........thank you very much. Have one more question.....if in those string of numbers and dashes I have a number in between [] can I just say for it to search for this in my query? Here's my example.... 99-569-78[00] Thanks again.....exactly what I've been looking for...

I've attached a sample database to attempt to explain better what I'm trying to do. I'm trying to find the right combination of using the Mid and Instr function to extract each series of numbers between dashes. With the sample query I am able to extact the first and seconds series of numbers...

Yes, I believe that would work, but I would really like to keep it all in Access. I'm still trying to figure how to use the Mid() and inStr() function together. Here's a sample of the data that I would like each series of numbers between dashes in seperate fields. ##-##-#-## #-##-##-# I've...