Search results

This should be so simple, i don't get it. I have a table of object ID's I want to delete the records in a much larger table. but i only want to delete the records found in my To Delete table... When i add both tables into the query design, link them, then try to delete from the master table, i...

Hey Everyone, I was wondering if anyone has come accross an issue with the Format Function in which if you use the Date.now as the date, it messes up the date. Example. If date.now provides the system date as 20/6/2011 Using the Format( Date.now, "mm/dd/yyyy") Gets you a random date such as...

Nothing like a good limerick for a chuckle. I figure some people must know some good ones! I'll get things started: There once was a man from Japan whose limericks just wouldn't scan. When asked why this was, he answered, "Because I always cram as many syllables into the last line as I possibly...

Hello all! I'm running Access 2003, and I have a List box with "extended" multi select enabled. My code: Dim i As Integer DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70 With Me.List26 For i = 0 To .ListCount - 1 If .Selected(i) = True...

I am running Windows 7pro. When I go to my Harddrive and select the "windows" folder, i can select properties, I get a folder size of 21.9GB on the disk. Ok fine, If I then go into the folder and select all Items within the windows folder. (ctrl + A) And then select properties, I get a...

I am new to the SQL databases and have been working on getting a few of our database applications converted to SQL Currently I have a database in which i upsized to SQL from Access. The backend data went over fine, and the front end linked up nicely using the linked manager. However, the front...

Is it possible to make a report off the information displayed on a form... specifically the values displayed in unbound text boxes which have been populated through VBA????

OK, currently I have a listbox which displays some results using an SQL query in the row source. In the list box i display records from a parent and child table. Therefor i'm getting duplicate information from the parent. (picture) This is what i want for display purposes. But I want to be able...

Ok, in a nutshell, i'm working with a form where i have a listbox. and based on a button the user selects, i want the listbox to populate with something. So I'm setting the rowsource to be an SQL statement, and then from there doing a requery. My SQL statement that works in a query is: SELECT...

Hey Everyone, I'm going to start by saying, I can program in Access Alright, and I have done a real small amount of work on our Server site with this mapserver, but I am by no means an expert. We have a map server that displays points, these points are linked to a database. Now to create the...

Firstly, people may want to read this article to know where i'm going with this. http://www.cbc.ca/money/story/2010/04/08/ontario-renewable-energy-duguid.html As a quick overview, the government plans on spending 8 BILLION dollars to generate 2,500 megawatts of green power which will create...

Hey Everyone, I have created a Database on our network. Now I know that people can open the database front end right on a network share without a problem. And call me crazy but i just prefer that the front end database be stored on a user's local machine. So i created a method that, on open...

Hey Everyone, I am in a REAL jam (Hey.. what's the difference between jam and jelly... nvm i'll save it for the joke board.) Ok I have a Simple Form with two charts. The record source for these charts is set using vba on a previous form. I have it so that i can have the user change the chart...

Hey everyone! Ok i'm still sorta new to the DAO stuff, so hopefully this question isn't too stupid but i'm trying to connect to a database on a network, from a database on a local machine. I want to search for a specific record on this network db. If anyone can point me in the right direction...

OK I thought i understood this, but apparently I don't. Firstly, A function returns a value, a Sub just does an action. I have created a subroutine that i pass some paramaters into. (A fileName, Starting value, Ending value.) They are all ByValue. There is nothing after the brackets. when i...

Hey everyone! Is there a way to import a text file but skip the first 10, or 15 lines? I have an output file from a program that our Hydrologist uses to predict spring melt runoff flooding. The output is a db file (not dbf) so i can only open it with text editor and bring it into access as a txt...

OK so I have a very strange bug. I am using Access 2003. on an XP machine with SP3 installed. I have a split database, the front end has a form for inputing new records. The user of the form has asked for a button to duplicate some of the information on the form for people where he is creating...

I have a database i created for our education department. They need a bunch of reports created, most of them work fine with the exception of this one report for school programs. The idea is this. A school can purchase a school program from us (Conservation Authority) Our educators teach the...

Hey, I know this is probably a silly question but, Is there a way to find out if any of your queries are used in forms or reports? I want to delete a bunch of queries in a database but I don't know if they are used somewhere as a reference or filter or anything.

Hey, I know this is probably a silly question but, Is there a way to find out if any of your queries are used in forms or reports? I want to delete a bunch of queries in a database but I don't know if they are used somewhere as a reference or filter or anything.