Search results

Scooter, Thank you for your reply. The only way I can do it is with the a main form and sub form? I can't have 2 subforms(1 master, 1 child) that I can link without having a main and sub? I have to lay it out like this TAB1 TAB2 ID NAME ID Value Text...

I have two tables called Tab1 with ID and Name Tab2 with ID, value, text Within the table def I made both Id's the primary keys. I went to the table relationships and dragged from Tab1 ID field to Tab2 ID field. Now what I want to do is have a subform from TAB1 and a subform for TAB2. When I...

I have a frame with two radio buttons. When the wizard created them I said no to have any defaults. Both are now gray when the form loads. How can I get both to be white with nothing selected? In my form open event I set the default to each option to false and nothing changed. Thank You for...

I tried this Format("1234B", "###-#L") and it didn't work still shows 1234B Thanks for your quick reply

bob, Thank you so much for your help. I'm close now but it is having problems with the character part of it. If I use Format("2222C", "###-##") I get back 2222C If I use Format("12345", "###-##") I get back 123-45 Is there a wild card for character? Thanks

I have a main form with a subform within a subform. Form C is within Form B and Form B is within Form A Form B is based on a record source that I set using VBA when the user selects certain drop downs and hits search on Form A. Form B has 2 Seperate keys that make it unique (recordnum and ID)...

nam, I'm F'ed LOL That is how it's working for me. It's just a mask the data doesn't have the dashes. Thanks for your help

I was wondering if there was a way for a message box to display a text box value with the input mask? I have a text box that displays 000-0000-0XX0 but when I message box this value it shows up as 00000000XX0. I thought this was something simple I haven't been able to find anything on it...

Gemma, I have all my tables in a back end DB. The only thing on the front end is the forms and queries. Will the front end still become corrupt in this scenario? I think it is cleaner to have everyone have their own copy. I will create a version table on the front end to keep track of which...

I will be speaking with him on monday. I think I can hopefully show him the best practices site and show that the FE gets corrupt and then nobody can use it. If after that he still insists then I'm going to go with the flow and if it doesn't work he will eventually make me change it or move it...

Paul & George, Thanks to both of your for your replies Jerry

George, Why doesn't it work the way I described? I'm trying to find the best way to describe it to my lead. He wants one copy that everyone opens. Thanks for your reply

Hello everyone, My question is about front end/back end databases. If I keep my front end on a shared network drive and allow multiple users(10-15) open the front end from this network drive will this cause me any issues or will access open an independent copy of the front end for each person...

Bob, I just figured it out. My function that I call onload of the form was checking to see if the user who is trying to open the db has the rights too view the info. If he does then I want to fill the start up form with his specific data. I changed my function to return back the windows...

I have a form that I want to set the recordsource to a query with a parameter passed into it. The parameter is derived on the onload of the form but i'm not sure how to set the forms recordsource to the query and the parameter? What i'm doing is taking the users windows login username and...

Brian, Thanks I forgot the -1. It's a Million and one times now. LOL Thanks Jerry

Mike Gurman, If I use the following code: IIF(InStr([FieldName]," ") > 0, left(InStr([FieldName]," "), InStr([FieldName]," "), [FieldName]) as Col1 that should cover all the scenarios, correct? Thanks again to both Mikes for your help

Mike, Thank you for your help that was it. I've used Instr a million times but for some reason it didn't pop up in my mind. Thanks again Jerry

Hello, I'm trying to find the first space in every row in a specific column Col1 ------ BOB JOE FRANK DAVE WILLIAM I need my result set to be BOB DAVE WILLIAM I've tried Select instrrev(COL1, " ") From Table1 I keep getting zero back. Once I get the position of the first space then I can do...

Cameron, I ran into a problem with that code I posted. In that query VAL is supposed to be my drop downs Value and TXT is supposed to be the visible text. Currently the VAL column is showing as the values in the drop down. How can I change that to make VAL the behind the scenes value and TXT...