Search results

Hey Wilson, are you sure you got the answer you were looking for? If you only want to export a table and don't need the records, just go to File -> Export. Then select your target (be it an Excel workbook or another access database - you need to have one ready to accept it!), and select...

Hi chewy, go into the properties of your text box. On the "On change" event, put something like this in your code: Private Sub Text0_Change() If txtTextfield.Text = "test" Then MsgBox "test was typed!!!!" End If Hope that helps! -Sean

Hey Autoeng, can you not select the ECNPartsID column, right click and "Hide Columns"? You can later, select Format - show columns. Hope that helps! -Sean

Thank you Pat - that does explain everything! I always thought that compacting only dealt with freeing memory - now I know better! -Sean

Hey misslee1888! I often use www.tek-tips.com for all my non-access needs. There is an ASP section here, so maybe the site would be willing to add another group...? -Sean

Wait until I explain that I had to re-configure the server and update the registry on all the client computers in order to get it to work - they'll think I'm a genius! (...the guilt goes after a while) -Sean

Hey Jack - I always do! It's just that this person's form had 6 subforms in it - all linked by that primary key. It would have been a lot of work for me to give her a "proper" database. It's kinda confusing too because they used the wizard for a lot of stuff so I just wanted to give them the...

Thanks again Jack - that's what I'll do! -Sean

Hello again Jack - thanks for replying (and thank goodness your working on a Sunday too!) :-) The problem is that, before I added the autonumber (I still haven't officially done this - just in a copy to test it) it did sort by the primary key (which is alpha - ie 1a, 2a, 3c, etc...). The...

Thank you Jack! Exactly what I needed! -Sean

Thanks for answering Casey! What I should have been clearer about was that the auto-correct part is working just fine. You start to type and the rest of the word does get filled in! Presently, once the auto correct has found its first instance, the user then clicks the little down arrow to...

Thanks for replying Tim! Is there not something else behind the scenes though? I notice that when I initially looked at the table, it was sorted by the primary key - when I added the autonumber it correctly numbered them in the order they were created (so the sequence went 1, 2, 8, 5, 3, 4...

Hello forum, someone asked me this question and I can't give an answer when I'm not positive. In a combobox, as you start to type, the rest of the word of the first instance starts to fill the field. My friend was wondering if it would be possible for the drop down to occur right after the...

Hello Forum, a co-worker asked me to prevent their form from sorting. She wanted the records to be sorted in the order they were entered, but they kept sorting by the id number (which was the primary key). I figured it was because of this that it kept sorting - to accomplish her request, I...

Hey Chris, go into the code (view - Code (from design mode)). Now select Tools - References and lookup "Microsoft Word 8.0 Object Library". Select it and then try your report again. Hope that solves it for you! -Sean ***edited**** I should also mention that I had a similar problem before...

Hey Peter, to start you off go into the code part of your command button. You'll want to type in something like this: Private Sub Command0_Click() If MsgBox("Are you sure....?", vbYesNo) = vbYes Then 'action to perform Else MsgBox "Aborted!" End If End Sub If you follow the logic...

Thanks Rich!

Hello forum, am I missing something? I want to insert a carriage return in my text box: =[FieldName] & Chr(13) & Chr(97) & "some text" I tried all combinations with 13 and 97 - also with and without the "$" after the Chr part. What I get is a [] (box) or the letter "a" - I read a similar...

Hey Witchity, I'm not positive, but I don't think you can do what you're asking (directly that is). It is a common database practice to create things called views instead which give the user the appearance of working with a table. For this example, let's say that the column which you want to...

Hi Mura, ***edited - just reread your post more carefully - you can ignore this paragraph but the next may still be of some use ***open your report in design view and click on the Sorting/grouping button at the top of your screen - the department is most likely listed there with Ascending...