Search results for query: *

Is there anyway of capturing the name of the button just clicked in its OnClick event? Obviously I know the name and so could 'hard code' it in, but I'd like to call a particular function from many different buttons within my app and I need to pass the name of the control used to that Function...

I have a field on a form which displays the values from a text field from a table. There are numerous formats (i.e. combinations of alpha and numeric characters) that the values can be in but I need to test if the value matches a specific format, e.g. nnn-nnnnn (where n is any numeric character...

Hi I have a large approx. 400,000 records which have a text field of up to 250 characters in length. I would like to search for a text string of a particular format, for example, LLL-NNNNN where L is any letter and N is any number and if found, I would like to extract the particular string from...

Hi, I have been sent a couple of presentations done by other users in our office. Some of the slide headings etc. are in Century Gothic font and are bold. For some reason, these refuse to display on my Computer and the test is invisible. If I select the text or the text box they are in and...

Apologies if this is not the right board - wasn't sure if this should go here or in the Queries section! OK, I have two table, one has a list of Users and the other has a list of Divisions they could belong to. So, something like: Table 1: UserID Username etc. Table 2: UserID DivID A User...

OK, I have searched on Google for too long and can't find an answer (maybe my search requests are badly worded). I have a Document which is a Test Plan for a Web Application. One of the things we enter on the Test Plan is the current Version Number of the application. This is currently...

OK At home I use Vista Home Premium and at work I have Vista Business. Until recently I was able to remote into my work PC by connecting to my company's VPN and then opening RDC, entering the IP or Computer Name of my Work PC and logging in. No problems. Just recently however, I cannot login...

Newbie to SharePoint 3.0 and run into a problem. I created a very simple test database in MS Access 2007; 2 Tables: Table 1 has the following fields: ID Document Number Sheet Number Title OwnerID Table 2 has: OwnerID Owner Name OK, so I created a query using both tables, linking them on...

Hi, I have a lot of data which contains strings such as X85123 or D2345B etc. What I would like to do is split these strings into the alpha and numeric sections, so I would end up with X, 85123 and D, 2345, B Any ideas most welcome Many Thanks.

Hi, I hope this is the correct forum to ask this question! We have received a SQL backup file of data which we are transferring from an existing database into a new database. There are several 'date' fields in the existing data which have the date stored as an integer. The format of this...

Hi I recently got upgraded to Office 2007 at work and I am having problems with my forms. I have several forms which are set to a certain size. However, Access 2007 continuously resizes them to fit into the available window size. Auto resize is set to No, Fit to Screen is set to no and Border...

OK, just moved to Office 2007 a few days ago at work and I am ready to uninstall it due to the frustration that is MS Word. Right, in my word document I am trying to change the formatting of some lines of text. If I highlight a single line of text, the WHOLE document becomes bold. If I...

I am currently overhauling a databse application we use. Some of the changes are functionality changes but I am also changing the styling of the application as it is looking a bit jaded. On each form (and there are about 40) I am changing the format of the text boxes, labels, background colours...

Not 100% sure if this post is relevant to this board but anyway, has anyone come across people with amusing names? Genuine cases only. The reason I ask, I got an email from my friend yesterday who had to make a phone call to a Mr Hugh Deeney. Now there's a guy who could get out of any situation.

Hi I have two cells in Excel with a date and time in them. One is 05/12/2006 09:49 and the second is 15/03/2007 17:00 I need to calculate the difference between the two cells and display te result as the number of Days, hours & Minutes between the two values. I have tried a couple of...

Please help, this is driving me insane. I have a button on my form which when clicked, it should filter my form. I want to filter it to show all records where a particular field is Null. I have tried every possible combination I can think of for the DoCmd.ApplyFilter method but I cannot get it...

Guys, need some assistance if possible. I have a sliding scale of charges for particlar items, so depending on how many are ordered te price per unit may vary. Example: Item Number | Cost 1+ | Cost 1000+ | Cost 5000+ 1 4.00 2.00 0.75 2 3.00...

OK, I have a form which is used to create the values required to create a new record. One of the fields is built up by the user selecting one or more values from a list box - if more than one value is selected then it becomes a comma separated string, i.e. value1, value2. I then need to have a...

Hi I would like to add a list box to my form and then have a button which when the user clicks it, will gather all the selections highlighted by the user in the list and turn them into a comma separated string. Example, suppose my list contains the numbers 1 to 10, and the user selects 3 4 & 9...

I have an access database which is a front end .mdb (one copy on each users PC) connected to SQL tables. For some reason, on two users PCs, when they make a selection from a particular combo box they get a pop up error window which has a large Black and Yellow exclamation mark and a blank...