Search results for query: *

I'm trying to find the number of years between two dates: The first date is a persons date of birth compared to todays date. I'm using the query grid in Access. The formula I've been wrestling with is this: Years Old = DateDiff("yyyy",[DOB],Date()) I would like the result to give number of...

Hopeing someone can assist. I would like to send the contents of a list box to Excel. Is this possible? If so, I sure would appreciate some assistance as to how. Thanks Roger

I used the following code in Access 97 to open a RecordSet within a Function for follow-on processing. When I tried the same code in Access 2002 I get an error on line "Set rst". Can someone tell me if this is still a valid way to approach this. Public Function FindAuthStr(varx As String) Dim...

I have two tables: employee( employee-name, street, city) - PK employee-name manages(employee-name, manager-name) - FK employee name I need to find all employees in the DB who live in the same cities and on the same street as do their managers. Obviously managers are also employees so its...

I have a query named qryVacantSlots with two fields: "orgstrPrNbr" and "strestrPosc" I also have a listbox named EfficiencyListBox. sqleff is defined as a global variable. The SQL statement I'm using to populate the listbox is embedded in a Public Sub Below. The call I'm...

Jebry was so kind to help me with the following code I used for Rowsource in a listbox. However, I need to add another variable for seaching. The current variable it uses is "varx". I need to add an additional called "vary'. I was hoping someone could assist in properly formating...

I built a listbox and populated it by using Rowsource with and SQL statement. Is it possible to change the column names the query provides to the listbox via VB? If so could I request an example. Thanks

Is it possible to progmattically attach and SQL statement to Rowsouce? For example I would like the SQL statement to select five fields form a query and use this to populate the listbox. If so an example would be appreciated. Thanks

I developed a listbox with 7 columns. It will also have the potential of 50 plus rows. Can someone give me a basic example how to move from row to row when populating the box: For example each row will have a person's name, SS#, city, town, zip, and two phone numbers. I then need to move to...

I'm trying to insert a listbox on a form and then add items to the list box from a search of a recordset. I don't understand the basics of using a listbox verywell. I do have a basic understanding of VB. Can someone point me to a tutorial that gives a good explantion of the particulars on...

OK I'm struggling. I inserted a listbox on a form named "ExcessListBox." I then opened the form module and inserted this code in a procedure (button Click)to add an item to the list box: Me!ExcessListBox.AddItem = ab (ab is a string variable that had a string assigned) When I run...

I was hoping someone could help me. I have a number of "forms" I'm moving back and forth in to view data. The problem I'm having is when I click on a command buttom to switch to another form I get "flicker". Is there a way to avoid this? I'm running Acess 97. Thanks

If I create the Function below in a module off of "Form" and call the "Function" mulitiple times, will it create muliple instances of the recordset or will the recordset be destroyed in memory when the code in the Function reaches rst.close after each iteration? Obviously...

I'm using a class module attached to a specific form. My intent is to build a number of functions to search a query for information. How can I declare the recordset so its scope is visable to all functions? Dim rst As Recordset Set rst = CurrentDb().OpenRecordset("qryAuth/Ass&quot...

This has me confused. This program worked fine now I'm getting a compile error. I assume it has something to do with a unregisted library. However, my skills are basic. When I try to compile I get: Compile error: Can't find project or library Also the apersand is highlighted in the code after...

Hope someone can help: I'm trying to set up a wireless network on my two home computers. One is a PC and the other a Labtop. Both are running XP. Instead of the basestation I'm running two adapters Microsoft Mn-510 for the PC and MN-520 for the Labtop. The PC has a dialup internet...

I tried to find this at Microsoft's site through the Knowlege Base but did not have any success. I'm running Excel 97 and when using VB and trying to save a UserForm I developed, I get the following error message after hitting the save icon: System Error &H000FFFF (-2147418113) Catastrophic...

Hoping someone can help with this: Listed below is code for one of my modules. When I try and delete a record this code is activated. Basically it's function is to go through a recordset and find occurences of a name and report back how many instances it found. However, when I run the program...

I'm trying to custom build my own face for a commandbar button. Can someone give me a simple example. Also is there a listing anywhere for each ID for a button. For example ID:=3 is the "save" button face. In one of my older excel books it gave the complete listing of these button...

OK I'm having trouble having a custom toolbar display a new statusbar message when I run the mouse pointer over the button. I'm using a custom button but the new message "calculate" won't display. Here is the code: Public Sub AutoRunSheet1() Toolbars.Add "ClearTools1&quot...