I am automating a contract generation process using Access. The contract itself is 13 pages long and the report I created uses 13 subreports to hold the contract pages. Only two subreports have unbound text boxes for population from a contract info form (main form). I'm using a macro to print a copy of the contract report using the current record in the main form as the record source. All the text boxes autopopulate perfectly. The problem is that the first page (with two text boxes) repeats over 35500 times (exact duplicates) before printing the remaining 12 pages. The other subreport with text boxes prints only once like it should. Can anyone give me some advice? Bob
I have MS ACCESS 2003 and an ACCESS 2002/2003 format table of over 122MB. When I attempt to create a MDE file, MS Access creates a file called "db1.mdb" and the freezes; when I click on the ACCESS window the title line on top changes to Microsoft Access (Not Responding) and remains like that. I have tried to give MS ACCESS 2003 hours to compile/create the MDE but nothing is ever created. Doing a internet search there was at one time a similar post here at QAIX concerning this situation but I can no longer find the original post or any comments. So can anyone offer explanation/solutions for this situation again please?
hi just wondering what a computer administrator can actually do? can hey see all the other users files? and if another user deletes all their internet history & temporary files can the administrator still see what they have been in? any help plz much needed
I want to add data into a table using addnew statement. Whenever I declare a variable as database I am getting "USER-DEFINED TYPE NOT DEFINED. ". Example Dim Dbs As Database If I add DAO in front like Dim Dbs As DAO.Database I get the same error. Can someone please help with this problem. CNN
I am creating a database where I want projection of some calculating the date automatically. I want the data to be added to a table. I could use a loop command. Any suggestion will be welcome
Hi there, Wonder if anyone can help - I'm looking to create a database/table with millions of records - the records will be prefixed, and will need to be grouped in batches of 10000, and possibly subset as groups of 1000 - all ranges will start at 000 or 0000 and run to 999 or 9999 respectively. Anyone have any ideas how to do this ? Thanks !
I'm using MS Access 2003 (11.6566.6568). Until two days ago I was able to not only save queries, forms and reports but the Access database as well. Now I can save the queries, forms and reports for the current session only but not the database. However when I'm on the home screen for the database the save or save as functions are grayed out. After closing the database the newly created queries, etc. have disappeared when I open a new session. This happens with every database I open. Also, when I open a database then close it without modification the last date modified column in Explore is date/time stamped as the time I closed the database. Since this happens with every database the problem must be program, not database, related. Anyone else ever have this problem and found resolution?
Until two days ago I was able to not only save queries, forms and reports but the Access database as well. Now I can save the queries, forms and reports for the current session only but not the database. However when I'm on the home screen for the database the save or save as functions are grayed out. After closing the database the newly created queries, etc. have disappeared when I open a new session. This happens with every database I open. Also, when I open a database then close it without modification the last date modified column in Explore is date/time stamped as the time I closed the database. Since this happens with every database the problem must be program, not database, related. Anyone else ever have this problem and found resolution?
i'm a student nd now, i'm creating a database desing of an inventory system..can u please help me decide on what 2 do??? can i ask for ur opinions and samples...tnx a lot nd more power...God Bless!!!!!
I have tables that I joined in a query. I have to perform a date computation to produce my report. My problem is that the dates are separated by rows. For instance, I will have a record that contains the request when it was initiated and another record when it was completed via the status. I am a mainframe DB2 programmer, I used cursors to do that. How can I do that in Access? Do I need to contruct a module and let VB do the job? Thanks
Hi, My computer at work bit the dust so I purchased a new one. We have a access 97 data base which has a "reports" menu. After loading office 97 into my new computer I find that I can't run certain reports that I use to run with ease. I click on the button for a report and nothinh happens. Can anyone help?
I've added a pop-up calendar to {censored}. It works just fine except ... when you first click open the calendar, I'd like the date that appears to be the current date. In the design form, I can click on the calendar & change the date which initially appears, but I can't make it the current date. Is there a way to do this in the code? Here's what I'm using so far Private Sub Calendar_Click() Date.Value = Calendar.Value Date.SetFocus Calendar.Visible = False End Sub Private Sub Date_MouseDown(Button As Integer, Shift As Integer, X As Single, Y As Single) Dim dtDate As Date dtDate = Calendar.Value Calendar.Visible = True Calendar.SetFocus 'If Not IsNull(Date) Then Date = dtDate 'Calendar.Value = Date 'Else ' Calendar.Visible = False ' End If End Sub Thanks for your help! Caroline
Пожалуйста, относитесь к собеседникам уважительно, не используйте нецензурные слова, не злоупотребляйте заглавными буквами, не публикуйте рекламу и объявления о купле/продаже, а также материалы нарушающие сетевой этикет или законы РФ. Ваш ip-адрес записывается.
If you would like to report an abuse of our service, such as a spam message, please . Если Вы хотите пожаловаться на содержимое этой страницы, пожалуйста .
