Search results

Display an Excel File I'm rather lost here and was recently thrust back into the world of access and vba. Any help would be appreciated. I'm trying to create a database that I can use to import any number of different excel files of many exceedingly different formats and merge them into one...

Sorry, I have browed a bunch of pages looking for this, and I have it working halfway but I can't figure out the other half. I have a form with a combo box and a button and then a subform. I want to requery the subform based on the combo box. OK, so far easy have that working. The problem is...

I have a report that shows ids, names and 6 rows of numbers. as such Record 1: ID LName FName Total1 Total2 Total3 Total4 Total5 Total 6 Record 2: ID LName FName Total1 Total2 Total3 Total4 Total5 Total 6 Record 3: ID LName FName Total1 Total2 Total3 Total4 Total5 Total 6 Record 4: ID LName...

I am trying to search a field to find every value that is between ( and ) is there a way to do this?

I have seen several hints about how to do this, but I have not found a good answer. Sorry my vna coding sucks, do web and some VB but little vba. I am trying to import an excel spreedsheet that has blanks in some rows as well as a lot of pretty formating, such as some lines are centered etc...

I have a table with some 2 thousand records. I would like to number about half and then have any duplicate records numbered the same. Is there any way to do this using an append query. Thanks in advance.

Does anyone know how to make a form that will figure out compound interest. That is If you have a begining value of 100, and you want to the figure that every year the value will grow by 10%. I have a query that holds the begining value of an account and the interest rate and the number of...

I found a while back (but since deleted) a vb script that would merge whole like databases based on table names and field names. I am wishing to merge a bunch (20 or so) identical very large databases for conversion to a new program as one database. Has anyone heard of this script. If not can...

I've seen several things on this topic so sorry if I am reasking. But nothing seems to work on my specific problem. I have a form that opens filtered to specific records based on a subform. The subform is also based on a table. Currently what I have done is a query opens the subform. What I...

I am trying to use an IIF statement in an update query. To say that if the months is on a quarter (Jan, April, July,Sept or Dec) then input a value, but if not then do nothing. I tried to start simple with Just January and did this UPDATE [Acct: Fixed Charges] INNER JOIN [xAcct: Fixed Charges...

I can see this problem has been talked to death but I saw nothing that works for me. I have a mainform with a textbox, based on data entered in that textbox I would like to filter the subform. I would also like to be able to do a between statement. But we can wait on that. I used this found...

I am attempting to get a value from a subreport to a main report. Using the expression builder I have set the value on the main report to equal the value in the subreport. But all I get is the last value from the field but not the next dozen. Any clues on how to fix this. I have searched the...

I have a report with two sub reports. Each sub report has totals by month. I would like to be able to add the totals to give a total due by month. The only catch is that not every month will have a total by month on each sub report One report might have august -November the other january to...

Would there be a reason that a field might not allow itself to be formatted as currency? I have a report that I have pulled a bunch of values from and it refused to format as currency. I have managed in the past to simply hide the field and reference it in another field and convert that field...

I have a formula in the detail section of a report recshipping, this formula calculates the total shipping if it is within certain paramiters, it is hidden for certain individuals and not for others. In the level and report footer I am attempting to Sum up this value. But when I do access...

I was working on this problem as a query with Pat Hartman and she said to do a report that does what I want instead. http://www.access-programmers.co.uk/forums/showthread.php?s=&postid=122934#post122934 I have done as she suggested with a report and subreports but my problem is now that if I...

I am using the "INT" conversion to convert to Numbers but I am losing my decimal places. Is there a better conversion I used Cint and had the same problem

If I have 3 tables all tied on ID Number two of which have dates. Table1.idnumber table2.idnumber table2.date table2.idnumber table3.date I want a select query that joins the three tables and grabs all the data in them based on month. I have been combatting this for 2 weeks and I am still no...

I have looked and looked and do not see an answer? If I have a report based on a crosstab query that has many null values. Here is the breakdown I am trying to do addition adding up several fields but if any one of the fields has a null value it does not return the sum. Is there a workaround...

How do you pull the tables name in a query?