Search results

Hello, I seem to have forgotten how to do this... I have a text field thats stores numeric data as text (for example 10, 10B, 100, 100H). I would like to order this data in numeric style, ie: 1 2a 3 3a 3b 4 5 How might I achieve this? Currently is sorting the data as 1, 11, 111, 2, 22, 222...

Hello, I have a numerical figure that a user keys into represent a month(for example 12) and a date field. What I would like to do is add the "12" onto the date field to come up with a date, "XX" number of months later. For example: number of months: 12 Original date: 01/01/2005 Calculated...

Hello, I have a form that I use as a basic log-in screen. The user selects their name then clicks a log-in button to proceed. What I would like to do is for an input check to occur. I tried making the underlying table name field required, but this doesn't stop any user from just logging in...

Nw Well, Thanks for the replies. I did download it - and it does indeed seem to be a northwind only demo. dj_T

Hello, I wonder if anyone has any advice concerning this subject. I have just been handed a database with about 50 tables and around 600000 (!) records! There are no relationships defined (!) in the relationships window - so its very hard to try and decipher what goes where! Can anyone...

yeah! Thanks for that. Works great :) dj_T

Hello, I am trying to create a simple message box but seem to be having some difficulty! I would like a message box to appear saying: "Do you want to exit?" with the buttons, Yes or No available to the user. If the user clicks yes the database will close. However if the user clicks no, the...

replacement Well, Thanks for the replies. Actually on Access 2000 it works fine for me =Replace([fieldname]," ","") . I was more surprised that there wasn't a more "basic" function to do this. We have Trim etc... but nothing that will hide or "parse" spaces in the middle of a string. Very...

Hello all, I am having real difficulty with this. I have a field with postcode data like this: "AB12 12CD" What I would like to do in my query is remove the middle space. Could anyone help? Many thanks! dj_T

Hello, I have a question that I think might also be useful to other users in this forum. I have a continous form that shows many records. I have designed quite a complicated form but there are some occasions where it may be useful to see the form (same data) in datasheet view. Apart from...

believe it or not.. Thanks again for your reply. Believe it or not, it still doesnt work :( "Path not found..." any ideas? Thanks! dj_T

Not sucessful Hello, Unfortunately the line is still not functioning. I tried these examples: C:\test test\test.mdb is the location of the database Call Shell("C:\Program Files\Microsoft Office\Office\msaccess.exe C:\test~1\test.mdb", vbNormalFocus) and Call Shell("C:\Program...

Spaces? Thanks! I can get it to reference the database - however how can i deal with spaces? For example: X:\Folder\My Folder name with spaces\My database name with spaces.mdb I have no control over the naming convention used - I must work around spaces in the name. Thanks again! dj_T

Hello all, I have created a form that I use as a menu screen. The user may click on a button and this opens a form. I would like to create a button that when clicked, opens another database file. Is this possible? Thank you! dj_T

Great! Great! Thanks that helped lots! Cheers, dj_T

Hello all, I have an unusal problem concerning dates. I have a button on a form that when clicked, sets a label to the the current date. However, what I would really like it to do is set the date the the last day of the previous month. For example, if I clicked it today, it would set...

No no..oh oh Hello, No that doesnt work. Its actually a combo box and whatever is entered in the combo box is mirrored in the control. The (clearer!) code looks like this: (on click event) Me.MyComboBox = "25/12/2004" works fine. However if I do this: Me.MyComboBox = Now() the current...

Hello all, I would like to place a button on my form that,that when clicked shows todays date in a field. The button code looks like: Me.myField = Now() Also I have a control that displays anything in myField. When I click on the "today button" the myField doesnt display anything, however...

Hello all, I have a main form and a subform. The main form has a tab control. In this tab control users can select a record by clicking on a listbox showing all the records. Other tabs then show various details about the record, including linked subforms with related data. I have noticed...

Great! Super - I got it to work! Cheers. dj_T