Search results

Hello I'm trying to have a cell display the information from which ever cell the cursors is on. I am trying to use (Master Info / Child info) for a subform but would like the Master cell link to where ever the cursor is. Is this even possible? Thanks Iain

Hello, I have made an OSK and am using the code TypeAlphaNum "6". This works fine until (the cell is set to number) I want to enter a decimal point. It treats this as AlphaNumeric (there's a surprise!) but I don't know what the code would be to enter a "." into a number field. Many Thanks Iain

Hello, I suspect I am being silly in missing the special button but... I have a tab control form and when you select the next tab the screen scrolls down so that the first cell selected is at the top. But then I loose the tabs. How can I stop it doing this. :banghead: Thanks Iain

Hello. I have a form which shows costings of parts. When we get a new cost for a part we update the cost but then adjust either the retail or markup. At present I have loads of cells which calc the price difference based on Current markup giving calculated new retail user defined new markup...

Is there any way in which I can get a drop down menu to automatically drop down as the user starts type? Thanks Iain

I have a mainform which shows a single record, I would like to have it also show the previous record. The user is picking parts, the main area is to show them what to pick next and I want it to show what they just have picked. I thought about having a subform which would contain the identical...

Hello all, I have a query which doesn't run properly unless the user has put the cursor in a cell which contains data. The data is in a subform. If they leave it in the bottom (make new) cell then it fails. Please can someone help with regards to either making the cursor go to, say the first...

I have a form which has a field which has an e-mail address in and would like the Sendobject to take the e-mail address in that field and put it in the to line when the e-mail opens. I thought it would be as straight forward as Form![Customer]![email] in the TO box within the macro but, it...

I have a subform and some of the users keep typing in it without a master record and thus creating orphans. I really don't want a pop up box. Would there be a way that the subform was invisible if the user hadn't added a record to the master. I was thinking in if user id is less than 0 form =...

Hello, I have done a search and can't find an answer to this. I have a main form and when you start to fill in the fields it will fill the default values for the others. If I start filling in the subform before entering in the main form the data is lost. Is there a way in which when entering...

Hello, I have a macro which runs several queries, some of these queries do not work on some of my computers. It doesn't bring up any error message and looks like it is running properly. I'm not sure where to start looking for a problem. If I run the query on its own then it works fine. Any...

Hey, Think this is a bit of a silly question but I can find anything about it. I have a select query with the criteria that the user enters. Is there a way I can get it to show information that is contained in the cell but may have other text in there as well? Find James when the cell...

Hello I recently found the shortcut CTRL + ' will take the information from the field above and insert it into the next row. But I want to take information from the previous row but different column and insert it into the selected field in the next row down. So for example Part Number...

I would like to get Access to add the contents from a specific cell from the row above and put the details into the selected cell. I would like this to happen when the user selects either a button of shortcut key. This is used when we type a part number in and it suggests a different one (...

Hello, After hunting high and low online i'm not even sure if what i'm trying to do is possible. I would like to select many fields where one field = yes, or select different fields where that field = no. This is used for if a person wants the parcel to go to their home address there is a...

I wish to have only the letters within a string of text underlined. Is there an input mask which would be able to do this. e.g. 123ABC456 would be 123ABC456 Many thanks

Hello, I have a list of orders, if the order contains fewer than 5 lines, and doesn't contain a large item (marked in the stock record in a yes/no box), I would like it to group these into 6 orders so I can have 6 orders of 5 lines in a report. If the next order does contain a large item I...

I have a form in datasheet style as a subform (subOrderForm). As I type in a part number it then completes the next columns with the name, price etc. I have another subform (subPartDetails) that is also within the same main form (customerForm) that contains information (pictures, specification...

Hello, I have the above message box appear. No problems to get rid of it. The main problem is that when I do it then messes with my code and asks for input data which it collects from various fields. If I turn the message boxes back on then it is able to find the data and continue. Please can...

Hello, I have been able to set up a running stock level but I am trying to get it to show it in a datasheet view. So that as I type in a part number for a client it will give me the running total depending on the part number in that row. At present it will give me a big error because it...