Search results

Hello all, its been a very long time since I've been here. I'm having to brush off the dust and get back to using Access a bit here and I'm tasked with trying to set permissions on a database which our department uses. The actual database I will eventually set permissions on is an Access 2000...

Has anyone been following any of this immigration stuff lately? Last weekend there was hundreds of thousands of people marching in L.A. and other various cities. I know we've talked about immigration on the forum before, but what is your take on what is happening now? Since I have not...

Our company is in the process of constructing a new corporate office and we will make the move in a couple weeks. Pictures of the development have been posted on our intranet and I find it kind of humurous to see that instead of the 2 little coffee makers we currently have the new office has 4...

Well, its been 1 full month now that my wife and I have been routinely exercising and dieting and so far so good. While I do not know what her beginning weight was I believe she has lost about 15 pounds in the last month and I have lost about 6 pounds. My goal really isn't to lose weight so...

Whether you like Chuck or not this site had me laughing my butt off. http://www.4q.cc/index.php?pid=top100&person=chuck

I was wondering what sort of things anyone will and will not tip for. I usually pay around 20% for dining out unless the service is really poor. For years I never tipped my barber because I'd never heard of it until someone mentioned it to me a couple years ago and I've since found that its...

Yesterday was a terrible, horrible, fowlest of football days I can recall. :( :mad: :( Not only did my Bears lose, my Colts lost as well. Ugh. Bears started game off bad and looking back on it they actually may have won if not for a couple bad plays where their corners slipped and fell and...

For a while some co-workers were trying to convince we to get World of Warcraft and while it did sound like a lot of fun, I couldn't come to grips with forking over $50 for the game, ~$80 for a video card upgrade and then shelling out $15/month just to play the damn thing. About 6 weeks ago...

I'm using Access 2003 and winXP. I built a database a long time ago and it worked fine, but some things have changed in the data and required output so I need to tweak some of the program. The following code ran fine before and copied 100% of the data from the query to the table, but now it is...

Have you ever just sat there and listened to many cell phone's ringtones people have? With the exception of ringtones that are clips from well-known songs, why is it that most of them sound like they came straight off the soundtrack from some porn movie? :confused: :eek: Or is it just me...

I'm using Access 2003 and a week ago I ran into a very strange problem with one of my tables. The table has 15 fields named Field1, Field2, Field3,....Field15. The weird thing that is happening is if I open the table in design view it will list the fields in order (Field1, Field2...

I work for a wireless carrier so I'm using the standard Sony-Ericsson T637 that they issue all the employees. Although it is not a high-end phone it is a good phone all-around. I also have a Nokia 6800 for testing purposed. It doesn't have as many bells and whistles, but its transmit and...

I've been having trouble finding an answer. Our office shares an Access 2000 database on an win98 machine. Most everyone in the office has been upgraded to winxp and office 2003 pro. The database is not split on the win98 machine and to my knowledge everyone just has a shortcut to the db on...

I've been trying to search for an answer but haven't had any luck. What I'm trying to to is loop through a text file but not sure what the correct syntax is to do so. I've worked down through a text file like such: open "c:\textfile.txt" for input as #1 do until EOF (1) Line Input #1, a...

I'm running a simple bit of code to delete the contents of a table and then populate the table based on a query. The problem is when I run the query I get 776 records. When I run the code to populate the table with the query then I only get 771 records. Can anyone help me to understand why...

I've written some code to write some query results to an excel file but I'm getting an extra file saved that I don't want. I have my database located in "My Documents" but the pathname of the file that I'm trying to save to is different. When I run my code it saves to an excel file based on my...

I don't remember if there is a way to do this or how to do it but I'd like to declare a single quote constant but I don't know the correct syntax on how to do this. For example, if you declare a regular double quote constant it is done like this Public Const Quote As String = """" what I'd...

I'm using Access 2k and win xp. I created a form based on a query(qryMTX105). The unfiltered query had 1500 records. I have a textbox on the form to enter a number that I want to filter the query on. I never really created forms based on queries or tables before so I think I really goofed...

I'm having a brain fart now and I'm unable to find anything that is helping me. I'm using Access 2k and I'm trying to design a create table query where I'm thinking I need multiple or nested if statments but don't know how to do them. Below is a example of the Field in the table that I'm...

I have 2 computers connected over the network. Both computers are using win98 and access 2000. Computer1 has the backend tables and computer2 has the frontend that's linked to the backend over the network. If I try to run some code on the frontend I get an error message saying "It is already...