Search results

thanks, anyway!

This doesn't work...I'm still getting the "you have tried to assign the null value to a variable that is not a variant data type" error... any other ideas?

I have read several posts on this forum about this problem, but none of the solutions presented so far help me. I have a combo box w/ three columns in it (2 of which are invisible). When a user enters data in the combo box, the other two columns are used to update info in other fields. The...

Yes the records are in a subform. The 15 is the an arbitrary number I picked because the person would never have more than 15 records to delete (probably never more than 10, really). And yes, it is running out of records to delete. I assumed that is why I'm getting the message, but I was...

I have a loop event attached to a field's after update event. Basically, it is supposed to remove the person from a variety of mailing lists if they are determined inactive. The code actually works, but after deleting the last record, it says the command "delete record" is not available right...

I know, "forms aren't for printing" but that's beside the point because my users occasionally want to print what's displayed right in front of them and I see no reason to go create a bunch of mock reports to do that... So anyway, I have used the PrintOut method to print a form that has a tab...

I'm still struggling with this, but I think I've narrowed it down, at least. It seems to be appearing only when users are accessing other databases (on their hard drives) where as the workgroup file is stored on the network drive and so is the database that the workgroup file mainly pertains...

I'm creating queries in an air quality monitoring database that will check for a set of validation criteria, such as: did the sample run the proper amount of time? I have a query set up now with the fields I need: Filter ID (with a parameter set to prompt user for filter ID they are checking...

The procedure recommended above achieves the goal of pasting the value into the field I want (I had to change Column (1) to Column (0) because the columnd 0 contents are numerical and won't allow me to paste any text (i.e. from column 1) into that field. But anytime I'm on a record that doesn't...

Actually, I was hoping to store it...to "copy' it from the lookup box contents and "paste" it into a field on the main form. It's being used if a person can't find a value in a combo box, they click on a button to search for a keyword within a value in the combo box using a custom dialog box...

This seems relatively simple, and of course I can get it to work, but not the way I want. I have a search results form that displays a list box using two columns (first column stores ID and is hidden). When I select the item in the list box to paste into a different form, the value pasted is...

That still doesn't solve my problem because I'm searching for duplicates based on two fields, but I have to see the results of the rest of the record to determine which one is the correct record to delete.

When I use the "Find Duplicates" query wizard, the results are grouped and there is a number given as the COUNT of the number of duplicates. I would like to see all of the duplicate records so that I can pick which ones to delete. Is it possible to change the wizard to that it returns all the...

Thanks for the suggestions...I'm happy to hear these responses since I agree...why create extra work for myself on the backend that then has to be figured out by someone in the future? Thanks again!

After reading through a number of posts here about the benefits of using an autonumber as the PK and setting a unique mulit-field index with other fields which I had thought of using as the PK, I have decided to go with the autonumber usage...however, I am wondering about the benefits of keeping...

Thanks for the input from both missinglinq and jfgambit. gambits code looks like it will help immensely and missing's points are well-taken. I will only be using this code for certain checkboxes under which situation if the user mistakenly checks the box I (the db administrator) would have to...

This seems like a simple procedure, but I'm not sure how to go about it. I have a series of checkboxes (most of which are independent of one another), and I want to prevent users from unchecking a checkbox that has already been checked. I do not simply want to prevent null values because the...

I'm sure someone has some thoughts/commentary on the usefullness of converting macros to modules. I've created my database to do some complicated tasks using macros as my VB skills are too limited to be writing full-scale modules (basically anything beyond simple command buttons and similar...

This may be a form-related question, but anyway, I was just wondering if anyone has any thoughts on the benefits/drawbacks to building a SELECT query statement from a form (i.e. by just clicking the build button in the form properties and going to town)...is it better/worse than building a query...

I'm trying to do something very similar, except I'm not importing data, but need to do it to make it easier on the users. Isn't there a way to make the "seq" field increment by one based on the changing value of the date field?