Recent content by Joye

I have searched and searched these posts in order to not post something already answered, but found nothing. I have been asked so many times be people I work with if I can just have a form which looks like a spreadsheet, I have always said... NO, but thought I would give a little time to...

I would have posted the database, but without the real data it works just fine. It is when I try to link to the real data it does not work anymore. So, I found a work around. I made a copy of my database with links to the tables, create the form and subform, it worked, then I went into my...

These all work great when I do a test run, but as soon as I try to link to the actual data, and create the subforms in exactly they same way, following all the same steps, it does not work. Guess I will have to find a work around. It just does not make any sense that this is not working.

I have "Allow Additions" set to Yes and Data Entry as yes and I added the code which was suggested above, for Add New record. Still it is not working. I don't have the subform and the main form linked, there is no Master/Child Link. So, why when I call up a record which I know has sale...

That does not seem to work. I am still seeing the past sales. You know how when you add a new button, to open a form. It asks you if you want to open the form in edit, or in add. Exactly. I want the same thing with my subform. I want it to view in ADD, not in edit. Thanks.

I hope this will be an easy question. I have a form which is capturing information about a site visit. Within that is a subform which is linked to a sales table. The main form is a ONE table and the subform is the MANY table. As each property only has one visit a year, but could have many...

The table is resident.

But I don't have any forms, no startup forms, not one single form is in this database. Just that one table. And when you open it it runs a query. How can I find out what it is running?

I have a very simple table with about 20 fields. The thing is it has about 360,000 records in it. It has always been a little slow to open, although using a query works pretty fast. There is just this one table, no forms, no reports, no saved queries. Simple database with one table, but it...

I have a simple If then statement which I need some help with ... basically this is what I want to say in my function procedure... Function val(cboVal as variant) If cboVal is = Greater then 1 or Less then 21 (or Between 1 and 21) Then val = "This" Else val = "That" End If I have the this...

I am going to try to attach an example of what I am trying to do. If you open the database and open FormExample you will see two tabs. The combo box on the top of the form will show you the data for whichever record you choose, but on the second tab I want people to be able to view all the...

AAAHHHH... it just does not work. I cannot get it to work. When I put in the column name it tells me it does not recognize it. I have tried putting the tablename.fieldname and tried just the field name, but nothing works. I cannot get it to recognize the field, and therefore show the nulls...

That does not work, it gives me an error message.

I already posted this problem in the query section, but got no where with it... here is the problem now... I have a form with three combo boxs - cboStatus - cboFunder - cboResource on my form. Depending on what you chose as an option the subform, which is based on a query will show the data...

Well I guess what throws me off here is that there is not "ALL" selection. If I type in that code above where the OR clause has = "All" nothing will show up since ALL is not an option. When they choose ALL, I need some type of code which says... ALL = everything and nulls. I am now using...