Search results

Strange one this. Apparantly random records of several Text or Memo fields in my database (of about 60,000 records) are being seen by Access as having data in them when there isnt any at all. It came to light when trying to append this and other data to a table. Although the text fields in the...

Silly me, thank you!

I have a form linked to a table containing stock information. When someone changes the stock amount, i want what stock item it was, when (time and date) it was changed and what it was changed to stored in another table. I got the following code to do this on an after update set MyRecords =...

thanks!

I have a database with some 30,000 records in, each with a date in ranging from 01/01/2000 to today. The field is called EnrDate and it is of Short Date format. I need to update the day of each record's EnrDate to 01 whilst keeping the month and year. How can i do this in an update query or...

thanks, worked great

I have a table with 108 fields. For a given record, data will be in some fields but not all. The fields with data in changes for each record. I need to update the records so that instead of a null value there is a 0. I cannot use the default value = 0 property of the table as the data is...

I have a table containing month fields from Jan01 to Dec09 (thats 108 fields btw). The data within these fields is a monetary amount, if it matters. There is only ever 6 records in this table. What I need to do is make a report based on the table that reads ACROSS, not down. I cannot do this at...

Is it possible via VBA to remotely open a database on another computer? For example, doing maintenance on a networked (but not split) database, when complete instead of telling users that its now accessable again, automatically opening the database on other computers on the network.

We have several buttons on a form that emails data via the SendObject command, through Outlook 2000. We recently updated Outlook with the Email Security Update and now get the error "2293". Microsoft say that this is to prevent malicious code from distributing attachments. How can I overcome...

Thanks, but i dont think thats possible on a network run on Windows 98? Otherwise yes, that would certianly cure the problem

Something that we do where i work: The DB structure doesnt change much at all, but the data in the main table does a lot. All we do is export the data in text file format (inc. field names) straight to floppy. Export your main table once and click the advanced tab and save the export spec...

Put the above code and your code on a On Timer event procedure of the form's main properties. Set the timer to be 60000 (60 seconds). This will then check the code every 60 seconds (or whatever you choose) and when it equals your selected time it will run.

I have produced a function in a database that relies on the time of a computer on a network. However, it is checking the code against the PC's time, and as all are not synchronised it is activating at varous times of each PC. The network is based on Windows 98 machines, and all the time sync...

Ive set up a timer on a form that needs to display a message box if ANY records are present in a table. Normally the table is empty, but if one record is present i need the message box to appear. How would I do this? Treat me as a bit of a novice please.