Search results

thermo nuclear explosions

Thanks Rich Toby

I am tring to test is a field is null on a form. If it is null I want to preform an action. However I am having problems checking to see if the form is null. The code I have is IF me.cbo_TrancheNo (isnull) then me.cbo_trancheNo.requery This Obviously does not work I am hoping for a few...

Thanks Rich et al - this is perfect

I have a form currently if someone moves off the form it automatically saves changes what I sould like to do is if someone makes a change on a form the tries to move a message box appears asking them to confirm changes or not...

I have now managed to get this to work using CurrentRecord

I am attempting to export data from my database and create separate data files for each record. I have created a form, and I am attempting to export all the records in the filter applied on that form. (This would depend on the dataset required at the time). I have attempted to do this by...

I have now resolved thios problem by going to a backup at 12:30 today and rolling the data forward.

I have attempted to do a repair on the DB but with no luck.

Hi, I need your help, some how my database has got corrupted, new when ever I try and navigate using the buttons on the forms I get an error "Module Not Found". I have been using "event procedures" to call VB code to open the next form. Any help would be greatly appreciated

made of poo

Mile/Cable We seem to be getting our replies slightly out of synch. :eek: Thanks for the help I will check out you suggestions this afternoon let you know how I get on...

I can post the structure of the two tables, whoever the query I run shows the correct information I just wish to know which fields within that data have not been completed yet? If you believe that supplying the table structure would help with this problem I am happy to oblige, I am just unsure...

Yes that is all I am trying to do, the database is normalised, I just have blanks where no data has been entered yet.

Sorry I will try and try explain more fully. We are collecting data from different sources and populating the database. I have created a query that displays the records that we are particularly interested in and shows that attributes we have collected so far. (This is the one described above)...

So what are you saying? That it cannot be done ?

we are collecting data on system/server attributes currently I guess about 80% is completed, However we have not collected data on all the attributes hence the fields are blank.

I have created a query that gives me results of records from across two tables. Currently it returns about 450 rows and 16 columns. What I would like to-do is find out what the number of the fields within the query that are null (or filled in). I guess there is a simple way to do this. Thanks...

I have created a union query, The query works correctly the only problem is that one of the fields types in the query is Boolean, The query now displays “-1”and “0” rather than “Yes” and “No”. I understand why it is showing “-1” and “0”. However is there a way I can get the query to display the...

After looking at the data some system have as much as 200 servers attached is there any way this could be done in VB. (although my VB skills need improving)