| Thread | Last Post | Replies |
|
| User Account Info | 05 Apr 2007 15:04 GMT | 2 |
Thanks in advance for your help. I need to write a script that will give me the users on a windows box and the date at which their password will expire. How is that done? thanks
|
| Totalling a field based on results of fields from a query | 05 Apr 2007 11:14 GMT | 4 |
I'm very new to Access and VBA. I've been reading and reading, but I can't seem to figure this one out. Any help you can provide would be appreciated. If I was using some other type of programming, I would try a do while loop, but I'm not sure how to do this in Access or where ...
|
| Filters in Access Projects | 05 Apr 2007 05:36 GMT | 1 |
I wonder if someone can assist me. I've got an inherited access database which for the most part uses bound forms (about 40 of them) to an access back-end. Database is in continuous use by around 10 clients. I am not very experienced with databases, but with a big pile of books I ...
|
| Problems with Automating range of sum for Subtotal method in excel after access export | 05 Apr 2007 05:34 GMT | 1 |
I've copied a recordset to excel and I want to do some formatting on it once its in excel. I'm having a real problem with the subtotal method - its the 'TotalList:=array(1,2,3) etc that I'm having trouble with. I need to insert an array into that value to get totals for
|
| Totalling | 05 Apr 2007 05:23 GMT | 1 |
I'm very new to Access and have been assigned a very complex issue (as least to me). I'm hoping someone will be able to help me or point me in the right direction. I have a form that I enter data into, this in turn calls a display form that
|
| Need some help with working on data | 04 Apr 2007 21:52 GMT | 4 |
I am very new to VB coding syntax. I have to download data from a website. It is excel format. I need to import this table, separate the name fields in order to match records for ID numbers. These records come without ID numbers. I end up putting them in manually, 'cause I ...
|
| Code to loop through records | 04 Apr 2007 21:50 GMT | 11 |
I need some help. I am way new to the VB coding syntax. I need to take variables from one table and separate a text field and save variables into the other table text fields. I cannot find out how to save programmatically, either. Not using SQL tables, using Access 2000 ...
|
| Suppress the Write Conflict Dialog Box | 04 Apr 2007 20:16 GMT | 4 |
I have a form producing a datasheet-view of multiple rows showing "today's schedule." I have written SQL code to update selected fields within a row (such as how many people showed up and the times they arrived and departed), and associated data that is not displayed (such as ...
|
| Running a .JAR file from within VBA | 04 Apr 2007 19:40 GMT | 1 |
I'm trying to write some code to run a .jar file when a button is clicked on a form but I'm having some problems. I tried using the Shell() command but no luck. Here's what I tried: Private Sub Command0_Click()
|
| Can't delete a record with this slightly modified code: Access 03 | 04 Apr 2007 18:34 GMT | 4 |
Private Sub cmdDeleteServer_Click() On Error GoTo Err_cmdDeleteServer_Click If MsgBox("Delete this server?", vbYesNo, "Delete") = vbYes Then DoCmd.DoMenuItem acFormBar, acEditMenu, 8, , acMenuVer70
|
| SQL Syntax - Parsing code Vs VBA | 04 Apr 2007 17:49 GMT | 2 |
The below is the equivalent SQL created by Access by parsing from the query that I made from the user interface. SELECT Gate_Data.page_1, Gate_Notes!note_num & ") " & Gate_Notes!note AS Note1
|
| last record for each date | 04 Apr 2007 16:45 GMT | 1 |
i need to get the last record for each day in a table, there are a few records for certain dates. Thanks for the Help. Jennifer
|
| call Word document | 04 Apr 2007 15:06 GMT | 3 |
Is is possible to call and print a Word document (template) from Access using vba? Thanks
|
| Help with Building An Expression | 04 Apr 2007 14:52 GMT | 4 |
I am dire need of making "if"/"then" type of calculation. Example: Fruit Type: Net Weight:
|
| Need help with this | 04 Apr 2007 14:06 GMT | 3 |
I am working on developing an application for my company and I have got struck up with a step where, it looks like, I need to do a loop through my
|