Search results

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...

Yes I see how it will work, but how can I get it to return the nulls as well as ALL the other ones where the field is filled in? I just cannot get the nulls to appears as well.

I know there have been many posts about this, but I cannot seem to find one which applies to my sitation. Here is it. In my main form I have a combo box which has 4 drop down choices. I have a subform based on a query which will show the records based on what is chosen in the combo box...

I have a form with a subform attached - the subform is just a datasheet view based on a query. I have a combo box where the person would choose the drop-down status they want - "Live/Likely" "Archived" and so forth. Then the subform refreshes and shows a list of all the projects with the...

ALSO - in response to the Before Update idea. I don't understand where to put that code. I can see Before Update on the form properties, and Before Update on the text box properties, but how do you go in and do a Before Update or After Update for the Current Record.

I am using a Next Button for navigation. The previous button works just fine, tell me I am already at the first record and cannot navigate - but the next button will take you to a blank record every time, instead of telling you that you are already at the last record and there is no next...