Recent content by dgmorr

Thanks again Bob! The only problem I am having is with Me.YourButtonNameHere.Enabled = False It won't allow that while the object has the focus. How do I get around this?

Thanks Bob! I just came across the Me! in another thread, but the last part is what I also need. Is there anyway I can have a pop up when the button is pressed as a double confirmation that would execute the function if the Yes button is pressed in the pop up box?

Hey guys, I haev a form from which I have users input data. I would like to have a button when a record is complete and does not need to have any more work done to it. I don't really know where to start. I have a field in the table that signifies whether or not the record is complete. I just...

Hey guys, Is it possible to have a data grid view AND regular text boxes on the same form? How would I do this?

I'm trying to run a make table query, and I'd like to automate it. Is there any way I can do this through a script so that I don't have to answer Yes/No to any of the pop ups? I turned off the notifications, but I still get the odd pop up.

Thank You!

Hey guys, I'm trying to pull data that has a due date within 30 days from the current date. I'm trying to use WHERE x <= Now() + 30 but I'm getting incorrect records. Can someone please help me out? Thanks.

For example, one person has a birthday, first day of school, first day of lost tooth, first graduation. These should be separate record entries?

They are dates relating to different events for each record.

Hey guys, I'm a little lost in my logic here for some reason. I have a table that has 6 dates. I'll label them as 1 to 6. Date 1 > Date 2 > Date 3 > Date 4 > Date 5 > Date 6. I would like to run a query to ensure that this holds true. Can anyone give me a little help on this? Do I have to do...

Hey guys, I have a field in my table that displays as a Combo Box with it's values coming from a defined value list. When I display this box in a columnar style form, the drop down works, but when you select something, it still shows a blank box. The data is actually written to the table, but...

I am having trouble with a make-table query. I run a query that populates my website with data daily. I have a bunch of fields in the db that I wanted to be displayed as one field on the website, so in my query I concatenated them. My website is able to distinguish which fields are text and...

Hey guys, I'm not sure what happened, but my database size has gone from about 60MB to 290MB. I have added about 10 new records and had an AuditTrail function keeping track of history. I had problems with too many entries in this field, so I deleted the field and started fresh. I have also...

Me!AllProducts = "" came up with the same error as above IsNull(Me!AllProducts)=True returned.... Function call on left-hand side of assignment must return Variant or Object. Ahhh, I thought this was going to be a simple query.

I'm having trouble getting that one to work. 'Objecto does not support this property or method' pointing to Me!AllProducts = Null