Search results

Q: How many elephants can you fit in a vw beetle? A: Four. A former boss of mine told this to us and died laughing on the spot while we all stood on in absolute disbelief that this could possibly resemble anything remotely close to a funny joke. To this very day and probably for all time be...

When looping through your table have a line that tests this: If len(phonenumber) = 0 then phonenumber = ""

In your design view type "Is Not Null" for your condition on that particular field.

Thank you both for you time and suggestions. I'll post back if I have any troubles.

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...

Oops. Guess I was a little too late with the response. I like WayneRyan's much better. :) That's a very nice sample database there.

Well, if I'm following you correctly you can try something like this in the event procedure of your command button that will open a query: DoCmd.OpenQuery "Query1", acNormal, "", "", , acNormal DoCmd.MoveSize 5000, 2000, 5000, 5000 The numbers correspond to: DoCmd.MoveSize Right...

Ok I see what you're saying now. I think that should work. I guess I wasn't looking for a solution by changing locations of the actual files but I'll give your suggestion a go. Thanks.

I'm not sure I follow you. I should give more info here. Computer1 is my pc at work and computer2 is a co-worker's pc. Are you suggesting that I map a drive to my computer on her computer?

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...

You probably could use the "On Lost Focus" method and use a conditional statement(s) to check for validity.

Thank you Jon. Looks like I basically had a few syntax errors that is corrected now. Much appreciated!

I'm trying to change a criteria on a stored query based on the value of form control; however, it does not seem to be working. I'm using Access 2k and I have a form with a dropdown combobox and a textbox. Based on the values for these 2 form controls I want to change the criteria found in a...

I've written a stored query where in a form code I click a button and using QueryDef I alter the SQL so I can change the Field1 criteria based on the value of a combobox on the form. I'm getting a "Type Mismatch" on the SQL, but not sure how to fix it. Here's my form code for the button...

Thanks Pat. I apologize if I mis-stated my problem. I've created QueryDefs before with code so that shouldn't be a problem (hopefully!). However, just from what I've learned on this forum, you all say that it's better to use a stored query rather than an SQL query from code. The SQL that I...

Based on a suggestion from one of the posts on this site I tried to write a query that I will open from a form that has a criteria based on a selection from a combobox on the form. I'm using Access 2000 and the SQL for my query looks like this: SELECT Table1.Field2, Table1.Field3 FROM Table1...

Thank you for your response. Sorry it took a while for me to respond. This give me some good ideas on how I'll carry out this task. :)

I'm running Acces 2k and I have a database that basically is an audit program. I have approximately 80 tables that are "Master Data" tables and then the set of "Raw Data" tables. What I have here is 5 regions with 16 "Master Data" tables apiece. (5x16 = 80). A user will typically update 1...

Thanks so much, I'm incorporating your suggestions and I need to modify it a little but so far its looking good. I never used the IIF statement before and it certainly looks very useful. If I have any problems I'll report back but its looking good so far. Thanks again.

Or at least it's diffucult for me. Anyway, I'm using Access2k and I wrote a query that is comparing 2 tables. The tables have 11 Fields. The first table is the raw data table and the second table is the Master data table and I want to find and discrepancies between the tables and display the...