| Thread | Last Post | Replies |
|
| limit trial use of xls programs for prospective purchasers | 04 Oct 2005 16:24 GMT | 2 |
How do I limit the use period of my xls created programs for trial by prospective purchasers?
|
| Trouble with SELECT ... INTO SQL statement | 04 Oct 2005 16:12 GMT | 3 |
I'm trying to use some VBA to browse through the Tables of my Access DB and to create Back-ups in a separate backup Access file for the ones i want. To achieve the latter, i'm trying to use an SQL SELECT ... INTO statement identical to the one that's being created if i design a ...
|
| Date Formulas for budget "burn rate" | 04 Oct 2005 07:21 GMT | 4 |
I'm trying to calculate the budget "burn rate" by quarter. Is there a formula to determine the first date and last dates of the quarter given a date such as 11/15/05? We know that to be 4th quarter of the current year (10/1/05 - 12/31/05), but I need my query to determine that for ...
|
| Reference Library Objects list | 04 Oct 2005 04:10 GMT | 4 |
Is there a place or a list or a database or something where I can see which Reference Library I'm missing when I get a "User-defined type not defined" error when compiling the module? This happens when I use something like the "Save As" dialog box, for example. I just don't ...
|
| Access object error | 04 Oct 2005 03:47 GMT | 15 |
I am getting error messages stating that 'the object does not exist' when I run the following code, used to compare a current record with the last one for a consecutive increase in at least 2 fields of 15dB or more. I would be grateful for some help please as I have tried ...
|
| Help! Access isn't responding during long calculations... | 04 Oct 2005 02:40 GMT | 3 |
I'm building an Access application that does a lot of processing when the user clicks a button -- typically 10 minutes' worth or more! I've set up the status bar to show progress. This is important to me because of the long running time of the program.
|
| Force Access to purge its Excel memory? | 04 Oct 2005 01:41 GMT | 11 |
When I link an Excel sheet as an Access table, Access memorizes the values of all the calculated fields. When new values are plugged into other cells the calculated fields never change in Access. I can delete the link, close Access, open Excel to verify that the values in the ...
|
| Updating One Field in All Records | 03 Oct 2005 21:16 GMT | 4 |
Against all odds, I have another question. I need to go through the DB after reading in a file and update one field in each record for the whole table. And I have no idea how to do it. Once I've read the file, I need to sort it by Part_Num, Serial_Num,
|
| Recordset doesn't refelct changes | 03 Oct 2005 20:06 GMT | 5 |
Hi I have Continuous Forms defined as a subform. When i do a change to a field i see the change on screen . BUT the recordset is not reflecting the change until i change another
|
| scrolling a form with an interactive script | 03 Oct 2005 19:41 GMT | 5 |
I am writing an Access application that takes the user through a script. The interview is dynamic, so each answer determines what the subsequent questions will be. Thus, the text (in the form of labels) and controls for upcoming questions remain hidden and are only displayed when ...
|
| Programmatically locate date | 03 Oct 2005 18:18 GMT | 3 |
Could you share with me how I can find the date of the first Monday of every month programmatically? Thank you in advance. Ben
|
| Type Mismatch Error | 03 Oct 2005 17:29 GMT | 3 |
I'm getting an error passing a variable to another sub when calling it. I've created a user-defined variable. It has multiple variables, which I reference like: var.item1 = value. They are all Strings. The definition is in a Module called UserDefinedVariables. When the user
|
| Msgbox alert for existing records | 03 Oct 2005 16:13 GMT | 1 |
I would be very grateful if someone could please clarify the instructions to my event procedure: I am entering travel reservations into a form and need to be alerted if the "booking number already exists" and "ok to amend?" so i want to go to that record to update it, or not ...
|
| Error with Too few parameters | 03 Oct 2005 13:18 GMT | 1 |
I am super newbie to writing VBA and I would like to ask for any of your help please. It is so simple but I dont where to start. i would like to set up a text box which I could enter a string to search for name within the
|
| Reset autonum field programatically? | 03 Oct 2005 09:36 GMT | 2 |
Is there any way to reset an autonum field with Basic code (in an emptied table)?
|