Recent content by jatfill

I've never created one recordset from another.. setting your row source to the original string you used to open the recordset should work. Here's an example of what I use for searches. I test the record count for zero (no results), one record (open the edit form directly), and multiple results...

I jus wanted to post back & let all know I was actually able to implement my original idea by using a custom shortcut menu on the textbox. My intent was to create a LOW-level HTML formatting tool for a calendar of events ASP page. so my final code went something like this (adding bold tags in...

I'm sure we can work this out pretty easily, but first take a step back and look at what exactly you want to accomplish. Is this an automated function you want to run every time your criteria is met, or do you wan to execute it manually & compare the dates at that point? If this is an...

Public Function UpdateSTxt(ByVal strContent As TextBox) strContent.SelText = "impossible" End Function I added this in a new module and then call it from a shortcut menu command, available by right-clicking within the target textbox... so the menu command looks like...

Hi all, I've searched on this to no result unfortunately.. but I am wondering if it is possible in Access/VBA to reference highlighted content within a text/memo box. I've tried several methods but nothing seems to work. This is Access 2002/XP. So for example, if my message above had the word...

There is a good installation program (free, actually) called Inno Setup that will do basic package distribution & let you create folders, etc. on the target machine. As far as turning Access files into standalone projects, you would need the Enterprise version of Microsoft Office in order to...

I'm assuming then that you are building a table of first names, last names where the combo box their data. This is, to my knowledge, the best way of doing things that you want 'autofilled.' Here's some code I picked up not too long ago from Microsoft's Web Site & modified to "transparently"...

ASP definitely has my vote, glad to see it has been implemented!! I also like the idea of a code/samples forum, for frequently-sought code like email lists, etc. What about a FAQ section in each forum for popular/redundant questions? One last thing, this forum has been an invaluable source of...

if the number must be a multiple of 5, then it must be divisible by 5 & not return decimals, correct? so something like: InStr(([number]/5),".")=False could be used to validate that the number entered is divisible by 5 at the table level... I tried this on Access 2000 & it works very well...

in the query criteria, you currently have (I assume): --------------------------- (form search) Forms![formame]![PARTNUMBER] or (prompt for value) [Enter the Part Number] --------------------------- or something similar. If you want to perform a 'wildcard search', try changing it to the...

you can assign priviledges to individual objects in Access based on userrname/password. Look at Workgroup security & you'll see exactly how this is accomplished..

Re: Setting Access application options rockman, you definitely get the R&D award for that one... excellent stuff! :D

The fastest method would be to create two fields in the table that holds the note, 'createdon' and 'createdby' (or whatever anems you like), then set the fields'default values using the two respective functions you already have. This makes capturing the data transparent to the user & prevents...

I'm not sure if this can be accomplished through code since it is an application specific option, not per form. If it's 5 users I would honestly just send them detailed instructions on how to perform this task themselves. In the long run, this is going to save you more time than trying to patch...

If the module does the import and calls your existing specs, I'm guessing the existing line looks like this: DoCmd.TransferText acImportDelim, "Specification Name", "Table Name", "Path to File", True, "" Even though your import specification does not include the first row as titles, the next...