Search results

Hi, I just recently migrated my Access 2003 database over to MS SQL Server 2005 using the Migration assistant provided by MS. However at my business we have multiple workstations using this and when I try to use the database (through the access front-end) we get an error message saying that...

Hi, The problem is this, i have a combo box that as a result of selecting something it opens a form where i select a price by checking a check box. once a check box has been selected i can close the form and finish creating the invoice. however when i change a different combo box first i get a...

hi, i wanted to know if it was possible when loading a form could i check a query's content first. I needed to know if there is anything in the query or not. So if nothing is in the query then I don't have to view the sub form for the query jlabre01

Hi, I currently have a text box where I write in true or false in my form, this tell another form which option to use, I would like to use an option button instead, for some reason I can't get it to work. please help, jlabre01

Hi, I just wanted to know what the proper format was for setting the control source for a text box to an sql statement was? jlabre01

Hi, I'm trying to delete a paged in a tabbed form, this tab/page has a couple command buttons that won't let me delete them, when i do it gives the error 424 message. i deleted the event for each command button, then the button then the tab/page, and when i open the form in form view it just...

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, 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

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

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

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...

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

Hi, I would like to know if it's possible to open/close a subform in a form using a command button? jlabre01

Hi, I'm trying to make a query based form, so i start at one form that just has a combo box with all the company names, then i push a command button to open the next form, which contains the results of the query. at the bottom of the page i put a button to go back to the previous page in order...