Search results

Hi, I'm currently developing a new application that is an upgrade from a previous access app. Im developing in VB 2005 with the back end on to SQL 2000. i am able to cannect to the database view and scroll through records etc. However, is it possible with VB 2005 to edit the data in that is...

Hi, Apologies in advance if there is also a similar post regarding this issue! Basically i have a form with a split container on it. The left panel has a list of buttons for the user to select. The right pane i want the contents of it to change depending on the button that is chosen! E.g...

Hey there, I am wondering if there is somekind of tool that can be used in access that can run and locate any queries that are redundant and not used within a system. Also if there is any kind of tool that can be run that identifies fields that are in tables that are also not used in the...

Hi, The problem that i have is that i have a random number generator, between 1 and 5. now with the random number returned i want to selct froma table that row number! Now the table concerned does have an indexed autonumber field, but i dont want to match this in a query to return that...

Hi all, Okay heres my question I have a table with two fields ID and number, the number field is a a list of numbers (obviously) which are used as reference numbers. This field is already populated with values. My problem is that the user is to click a button (access front end) and a reference...

Hi all, I have a SQL table linked in to an access frontend, sometimes the table needs to be opened from the table view in access and filtered upon. The table has a primary key which is an autonumber, however when filtering on some data in the table the results return as if the table has lost...

Hi All, I have an access from end application with linked tables to SQL server. The tables are access by many users at the same time (multi user enviroment). The Users are able to scroll through, edit etc the records. However now and again users are getting the message box that there is a...

Hi All, I have an access from end application with linked tables to SQL server. The tables are access by many users at the same time (multi user enviroment). The Users are able to scroll through, edit etc the records. However now and again users are getting the message box that there is a...

Hi, I have a text box where users input a person name as it appears on their bank account. This text box can only take alpha characters and no numbers or other characters except the "&" sign. Please can some one help in to how i can mask this text box to only take text and nothing else, not...

Hi, Hope someione can help. I have a report with a text box that returns the curent date in a text box by just placing Date() in the control source. Which returns the date as; 13/03/2006 - which it should. However i require the date to be outputted a as 13 March 2006. Does anybody know how i...

Hi, We have a in house system that has a client side front end that is used by many memebers of staff. The backend data is held on the server and hence the front end uses linked tables. The problem that we are having is that when a user inputs a new record (which is very often) the record is...

This has got me stumped. We have a massive db and on one of the screens the users can scroll through the records and view information they can also add new records. When the users enter the new record and go back to it it has been successfully stored in the relevant table even on exitin the...

Basically i have a report that is raised every thursday, in the title i want to specify the date for the friday. For example this week the report will be raised on the 3rd feb, when it is the title wnats to read "Report for ...... 04/02/2005. I know that this is simple enough however, sometimes...

Hi, I have a table that contains a notes field. What i would like to do is to append to this field in table with some more data (notes), however i dont want to over write the existing data. I would just like to add to it. the current notes are added through the access front end, but in this...

hi there i hope that you can help with this. Basically i have a report that is raised every thursday, in the title i want to specify the date for the friday. For example this week the report will be raised on the 3rd feb, when it is the title wnats to read "Report for ...... 04/02/2005. I know...