Search results

Hi, I had a form with 4 tabs, now i have made 2 of them useless, so i'm trying to delete them. i got the first one deleted, the second one is giving me problems. the only things on the page is 2 command buttons, and for some reason when i delete the tab, then i look at the main page in form...

hi, So once the tables are linked from sql to access using the SSMA everyone can simply use the access database from the network and it will run fine?

Hi, I'm in the process of moving my company's access 2003 database to sql server 2005, i plan on using the MS SSMA to do the transfer of tables and data. I just wanted to know if I have to install MS sql server on all the computers in order for people to have ability to use the database? (i...

Hi, I wanted to know, if I can create a command button to change the value of a yes/no field value, this field will be in a table that isn't present on the form. can i do that? jlabre01

what if put a check box on the form to represent the field, how would i uncheck it? jlabre01

thnx, that helped a lot

Hi, I'd like to know if there's a way to change the value of a yes/no field by using a command button? I want to show whether an item is in stock or not and if it's removed i want the stock to reflected that it's not ther. jlabre01

hey Tyler, Ya your idea would work because everyone has a unique login. I would appreciate any help in setting restrictions to certain tables/forms, as I am still new at this. jlabre01

Hi, I have recently migrated my access 2003 database to sql server 2005 and i linked the tables, etc. in sql to the access versions, so that the company I work for can still use the access version of everything. I wanted to know if it would be easier to make a form in access for login purposes...

Hi, I wanted to know if it was possible to have a text box return more than one value? And if so, how? In my case, I want it to return the quantities of each item ordered on another form, all from the same order, just multiple items. jlabre01

oh ya, my mistake but how would I make that the value of the text box?

Hi, I want the following statement that I had as the control source for a combo box, but I want it to be the control source for a text box, there's some different formatting I'm not aware of to make it work, because it keeps saying there's an error, even though the statement worked for the...

Hi, I wanted to know if it was possible to restrict access to specific forms on the access side once the database has been migrated over to the SQL server? I will link the access database to the SQL server so that we can still use the access setup, but the info will be stored in the SQL...

Hi, what I would like to do is this, i have subform that is generated/made visible when a command button is pushed, the source for the subform is a query. the query brings information about a specific job after the command button is pushed. what i would like to do is add another command button...

Ok, thanks. I got it to work :)

Thanks a lot, that really helped :)

ok but how do i do that as a control source for a text box?

Hi, I'm working on designing a special invoicing form for my business and in order to do so i need to check a couple different things when it looks for the price, I just wanted to know if nested if statements are possible or not? jlabre01

Hi, what i'd like to do is have a combo box on the first page and when a value is selected i'd like the values associated with that selection to appear in their appropriate sections on the second tab/page on that form, is that do-able? jlabre01

Hi, I would like to move 2 databases into one, before i shift it over to the sql server. is that possible? jlabre01