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

Thanks for the FireStrike.........Works a treat!

Thanks for that i understand that but wht im unsure about is how in the query i can get it to return the relevant row from giving it the row number, that is what the syntax ofr it is! Bearing in mind as per my previous example, if 4 is generated and i want row number 4, the id for that row may...

well if a query will do it then ill try that, so i may have posted in the wrong thread.....Any ideas ???

sorry dont think i explained it properly. The random number that is generated, i want that row number from the table to be returned. E.g. Lets say the random number generates the number 4, i want to then select from the the table all the values that are in rown number 4! Hope this makes sense

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

Im using Access 2000, the table design is as follows: ID (autonumber), RefNo (Number) As stated befre the table is prepopulated with values, and just want some kind of random number picker! Thanks

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

Yes thats right, surely it should be returning those results in numerical order as my ID field is a primary key (also an auto number)

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

okay FoFa thanks for your help ill give that a shot

Thanks for the help, what would be the best tools to use in this situation

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

thanks, cant believe it was staring me in the face and was that easy Cheers

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

Private Sub Form_Close() 'appends new company numbers in to tbl_company_v_gabemref DoCmd.OpenQuery "qry_append_smcreg" End Sub this is the on close query that runs. The on load code is just siple locking of fields that are password protected!