Search results

Hi, i dont know if i am posting this in the right forum but i have a completed access database it consists of forms and querys. i just want to know can i make this database an executable file so when i click on it just the forms will appear on screen so the user can navigate through the forms?

hi, i have a basic database and i want to link it to a microsoft sql server via ODBC how do i create a odbc file?

Hi all, Just wondering is it possible to create a login in box in access with different user levels(ie one user has access to all forms whereas other users have limited access) Do i need to do some VB programming to grant the different access levels?

Hi, I am trying to link tables in my access database to an Sql Server (microsoft sql server 2005) does anyone know how i would go about this? or where i could find info on how to link the tables? Basically i want to have my access database tables stored on the sql server

Hi, i have a fairly large access database i want to transfer to SQl and eventually on to an sql server does anyone know how i would go about doing this. Cheers

I designing an access DB and just wanted to know how i put a username & password protection on it. any help?

ive areport with alot of data and it loks messy ast the mo how do i tidy it up so it looks more professional it all squashe donto 1pg at the mo fields r been cut short etc how do i extend it to two pages r even keep it all on on e pg but it looks professional

I want to create a report where it will generated details on data in my db Dependant on a data enter by the user.

hi all, I have a form which allows users to add and edit details about shop stores, it has all different kinds of info on these stores, name address etc what i need help with is, a store can have a number of cash registers in there store, from one to 10, it can also have inactive registers...

hi, does nayone know how iensure their will be no blank text boxes on a form ive created, user needs to enter data want to make sure they dont leave a blank text box thanks

Hi, I have a form that allows the user to enter data on business contacts all basic details on a company etc, i was wondering would anyone be able to help me in when choosing a country ie USA or Canada that it will recognise this and in the state field i have change it so if US is selected then...

hi, ive got a stores form where u add stores to a database, i also have a history form which gives information about the stores history, i want to be able to link these forms. Basically they are linked in the relationships via a store number, so when a user is scrolling through stores he can...

hi, when i add a record to my db via a form i want the focus to be on the first text box cant rember how to do it but i know its pretty simple, do i build event in the add command button, im using .setfocus/settext doesnt seem to be working any help?

Hi All, i'm looking for a really good access book that will help me progress my access knowledge i have an okay knowledge of access and wish to expand my knowledge futher any good books out there that can help i know their is hundreds of books but does any one have first hands experience of a...

I have a form that performs a task and i was wondering can i make this form into an executable to have on my desktop or is this possible

Hi all, i have a form with a text box and a command buuton, i want to be able to enter a number in the text box and click the command button this will then search a table for this number and bring up all the information in the table related to this number whether it be on the current form or in...

I a list of data in a list box and i want to be able to choose diiferent pieces from the list. How can i ref an individual record in the list box do you use ME.Listboxname.value something like that im lookin to move pieces of data from one list box to another for printing i can move all the...

Im tryin to move data from one list box to another ive seen some sample datebases and how they use command buttons to move the data back and forth from the list boxes (usually have <, >, <<, >> on the command buttons) Does anyone know how i do this?

I have a report which has details of the projects. I have them sorted by the year they were done and i was wondering can you the different years on seperate pages eg say 2004 had 4 projects that be on pg1 2005 had 20 projects that be on pg2 and 3 2006 had 80 projects be on pg4,5,6,,7etc is...

How do you use the < and > buttons when used as command buttons to transfer data bewtween two list boxes what code do i need behind these buttons?