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

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

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

I am working on a form and I have a next button and a previous button as well as a Add new Record button. When they hit next... I have it set up so that it will run a procedure which asks the users if they have made changes to the record, if they say YES, then it opens another form with...

I have a form with a combo box for a lookup. Right now it is looking people up based on their Current Family name. I also have a field for maiden name and I want to combine both the current name and maiden names into one column (not concatenate) so people can look up by using either. I know...

I am interested in sending two reports when the user hits the Email Report button on the form. I want there to be two attachments in the email. I can get both reports to open, but I can only get it so that it sends TWO email messages, one for each report attachment. Any ideas?

We have many users creating and inputting data from different offices all into the same database. The problem is that everyone has a different type of printer which is changing the way the reports look when they go to print them out and in many cases the reports are not fitting on the same page...

Ok, I have created a list box on my form where people can choose all the towns they are interested in seeing data from. Then I take all the towns and create a string expression to send to my query - storing it all in a text box. For example, say they choose... Chelsea, Monkton, Addison... in...

The problem I keep having is that I have a report with a small amount of information in it, and it has a subreport linked to it. The subreport contains most of the information I am interested in. The main information in the report takes up about 4 inches on the first page, then the subreport...

does anyone know how to edit records that are stored in a random access file. I am using a PUT statement, and everytime, no matter what code I have written to tell the computer that I am working on a record that already exists and that the record number is n, it still assigns the data to a new...