Search results

Depends on your definition of "empty". I would a query maybe with the NZ function. Select F1, F2, F3 from yourtable where NZ([F1],'') = '' OR NZ([F2],0) = 0 etc depending on field type. You could use an IIF and return a Y or N also. So it might be like. ID F1 F2 F3 etc. 1 Y N N 2 N Y Y 3 Y N Y 4...

1 - Store as separate fields and put them together when you need them 2 - Use a MAX query to return the highest entry for the current Pxxnnnnn and add 1 to it. 3 - write a function to determine it. search this forum since this had been answered like 15000 times.

Don't know if I posted this before here, but here it goes anywho: Which leads me to a true story about myself (FoFa) and travel. Back in 1994 I was in route to the middle east to do a software install in 4 countries. A little nervous because of the unrest at the time and being an American. My...

From Dave Barry, a humourist: Recently my family and I spent a week in London, which is a popular foreign place to visit because they have learned to speak some English over there. Although frankly they have a long way to go. Often, when they get to a crucial part of the sentence, they'll...

Well if the number of tables are small, just create a value list of the values. You could program it in VBA, but it might be a little slow.

Woodworking (small projects). But since Christmas playing Halo 3 online and gett'n my butt kicked :D

Blazing Saddles Forrest Gump Jeremiah Johnson

How about something like SFTP. Or get a opensource PGP encryption tool and encrypt it on one, and decrypt it on the other and use regular FTP, as two easy options.

I would see if a crosstab query would meet your needs (use help).

I think I would create a function that returned a number based on your criteria. So if x was 12, the first 12 rows would return 1, the second 12 would be 2, etc. If it was 4 then the first 4 rows would return 1, the second 4 would return 2 etc. Than you can use this value to sort your rows by...

Q 1 - There are a multitude of ways of doing this, you may want to start with an easy DLOOKUP and select the value from the prior record. Q 2 - This depends on how you determine the last record. If you table has an autonumber field, you can select the MAX autonumber value within the subset of...

I would disable any error trapping, and see if you can isolate it to the actual statement. just as a starter

Yea, it does appear that a lot of the "Better Ideas" when actually investigated (not the "sounds good to me" crowd not withstanding) turn out to actually cause more problem than they solve. It would appear the little bit by a lot of folks is a better place to start. Could you imagine the savings...

man, I have been searching, and have tried different code snippets (you should see my registry and .INI files) here is what I need. VBA code for Access 2003 using Acrobat Standard version 7.x. I need to run a report, and have it create a specified PDF file name. Will be running in a VBA loop...

Then there must be something else going on, or it is more complicated then you posted.

Try: SELECT s.Softwarenaam, Count(*) as Licenties from Software Where Licentie = True Group By s.Softwarenaam

Reverse will reverse the string so you can use charindex

Well the basics of this error is saying you have a character field (varchar) and you are trying to put it in a field defined as smalldatetime. And the data it is trying to convert is not valid for the smalldatetime datatype. Basically you have an error in something you are doing. Either...

PK1 is the tables primary key that would tie to the other tables primary key Try This; SELECT TA.PK1 , "Matched" as Rmks FROM TableA TA INNER JOIN TableB TB on TA.PK1 = TB.PK1 UNION ALL SELECT TA.PK1 , "Not on Table B" FROM TableA TA LEFT JOIN TableB TB on TA.PK1 = TB.PK1 WHERE TB.PK1 IS NULL...

It is basically saying a Macro named "Update" is running a command of "RunCommand" being passed a parameter of "18" (the true means the macro step condition is true).