Search results

Thanks for that, does seem a bit odd it needs to have the focus. Anyway, as i said previously i know all about tab order, but that is already used. There are 7 days, Monday to Sunday. 20 fields per day, listed down. A time from and a time to is entered in a row. Once you have entered this for...

Yup, and the tab order is set to go down... However, they also want to be able to move across when they have finished going down. Confusing i know, but i have yet to meet a User that isnt!

Hi All I have created a little bit of code, saying depending what field you are in, when you hit a key, it moves you onto the next field in the form. This works great.. However, there are 140 fields on this form, and i dont really want 140 pieces of code, so we thought we would use the...

Hi All Im trialing a new ADP, linking to a SQL database, with 30+ tables in it. I know i can create recordsets and SPs and add to a table that way, but that would take a while with what i have. So, is there anyway of using the MDB code, in an ADP? For a record add my code would be something...

Hi All Im having problems using a bit of code i found, i think from here... im trying to create an ODBC connection upon start up if it doesnt already exist. I can get the connection to be created with all details apart from the password, it doesnt seem to save it! Please could anyone have a...

Fair enough, thanks for all your help :) I'll start making some more forms! Least its one form for everything, can just change basics for every help part.

Yeah, ive made a few msgbox's so could do that. To save me doing all that, can i convert a file into a .hlp or .chm. Or if not, what software do i use to create a proper one?

Ahh, i never actually created it as a .hlp file, its created as a .html file. I guess this is going to stop me using it? :(

Hi, thanks for that... It kinda works, but instead of opening the file i have created, it opens the standard help menu but then opens MSN up, and searches for the file... I want it to actually open the file i made :( Any ideas?

Hi All Ive written a User Manual for my database, in HTML format. I wanted to use the Help File option of a message box, to have the help button open this file. Ive set the location to a Public Const variable, and then added the Variable into the code, example: MsgBox "Please enter a Paris...

Hi All Im having some Major issues with this problem, i only hope someone can help me!! Firstly, let me set the scene. I have 1 Form, And 1 Subform within that form. The form gets the Main Data, the SubForm gets all the Related Data (in this case, its all the Items Of Equipment this client...

Hi All Im using an access front end to add/amend/get data from SQL Server tables, when opening recordsets you need to use the dbSeeChanges as an option, which i am doing, and for Adds/Edits it works fine, however, when im trying to Get data, i get an error telling me "Data Type MisMatch". So i...

Hi All Im trying to create an Amend Form, which bascially amends a record that is already in the table. I open the recordset with the following code: Dim rstEdit As Recordset Set rstEdit = CurrentDb.OpenRecordset("select * from [eaOTFormDetails] where eaOtFormId = " & Me.OT_FORM_ID...

Hi and thanks for the URL Just having a play around with the program, and i cant seem to find a place where it would let me at a list of what to find, and what to replace with. Dont suppose you have seen this option anywhere?

Hi All Due to our ICT department, we need to bring our databases upto their naming convention standards. I have one database, with over 23000 lines of code behind around 20 forms. I have a table with the [Old Field Name] and [New Field Name] what i want to do, probably using a module is search...

Because your -1 to get the previous month, if i take it out it fails to work.

That would make sense, with a little bit of editing i presume you could make fields along the row into one.... Instead of like what im doing, and making values in the same column.

Thanks for the Idea, finally got it working with: =VLOOKUP(SUM(IF($A3<=Sheet2!$C$2:$C$73,IF($A3>=Sheet2!$B$2:$B$73,Sheet2!$A$2:$A$73)))-1,Sheet2!$A$2:$C$73,2,0) Sheet2 data, like you say was just a lookup table, of teh possible periods and a unique number. Working fine now thanks :) Scott

WOW! it worked like a charm, thank you so much Peter!! Scott

Hi All Ive been trying to do this for the past hour, and failing each time i try! Time to try and pick your brains :) I have a table, called "Clients". This is a list of around 6000 records, with 2 Fields in the table. Field 1 is "PARIS ID" and Field 2 is "SERVICE". Looking Like: 1002154 EA...