Threads Replies Last Post 17 Pages: 1  2  3  4  5  6  7  8  9  10  11  12  13  14  15  16  17   printdlg stopped working I have been using a printdlg module to bring up the printer dialog for two years. 4 weeks ago, it stopped working, no evironmental changes, no database change, I wondered if maybe it was a WIndows update or something as it happens on 75% of the PC's in the building. It seems to work on Office XP on my server2003 system, but not on Office 2003. If I call the exact same coding from a vb6 p... 4 21.11.2005 11:21:02 Multiple choice quiz database Does anyone know where I can view examples of mutiple choice quiz programs done in Access? I'd like to create one but I need something to go on. Thanks!!! Jeff ... 7 21.11.2005 02:09:59 Access VBA (Office 2000)how to add item to listbox and combobox Hi All I am doing a project using Access VBA (Office 2000). In that its required to add an item to 'list box' and "combobox" controls but I could'not made it through code...I know that for Office 2003 and Xp we can add it with 'controlname.additem' but there is support for method 'additem' in Office 2000. Please let me know the code for that Regards Vighneswar ... 3 20.11.2005 19:24:05 Finding all registered type libraries I have a need to dynamically establish a library reference in an application. This particular need revolves around the creation of reports in Microsoft Excel format. Not all users will have the same version of excel and some will not have excel period. What I need to do is determine if they already have a reference to Excel within their application. I have accomlished this by iterating the... 4 20.11.2005 19:13:58 Access2000VBA database connection string Hi All Could anyone please tell me how to set the "Access2000 database connection in VBA" that auto detect the MDB file path and opens the connection. I know that it is possible with "Set con = CurrentProject.AccessConnection" in Access2003,but I want it in Access2000. Thanks in advance Regards Vighneswar ... 2 20.11.2005 14:46:08 ado vs. dao Which one am I sopose to use, ado or dao? If I declare a recordset in A2003 like Dim rst As Recordset, what default reference is it pickiing up (ADOBD.Recordset or DAO.Recordset). Thanks ... 4 18.11.2005 15:41:31 How to calculate normal and overtime hour Dear all, I want to make a function to calculate the normal working hour and overtime hour. In this case, I have a shift hour from 20:00 PM - 05:00 AM (one hour for break 24:00 - 01.00 AM) If someone works from 19:00 PM until 06:00 AM, then the result is 8 hours for normal working hours and 2 hours for over time hours. The overtime is calculated from 19:00 until 20:00 and 05:00 until 06:... 1 17.11.2005 07:53:23 error, bad DLL calling convention Can someone tell me what is happening in the code below? What is the use of the $ for? This is what the code calls after a value is selected: SetSportName (Me.cmbSport) This is in a module: Dim cSportName$ Sub SetSportName(c$) cSportName$ = c$ End Sub Function GetSportName() GetSportName = cSportName$ End Function ... 4 16.11.2005 00:19:18 Selecting info from a recordset to a new recordset I figured out how to get my original recordset. Now I want to query the recordset. Using recordset.open doesn't work because the sql statement doesn't recognize the first recordset. I will conquer this or it will kill me. This is the best method I can think of to deal with my "like" issue. See post "Querying Like" Thank you Suzette ... 11 14.11.2005 16:39:39 Sql string format date error I did the folowing vardate = Format(vardate, "dd/mm/yyyy") varcustomerid = Forms!master!cmbfullname sqlstring = "INSERT INTO headmaster ( datefld,customerid)SELECT #" & Format(vardate, "dd/mm/yyyy") & "#," & varcustomerid cncurrent.Execute (sqlstring) but it stills put it as "mm/dd/yyyy" What am I doing wrong ? ... 11 14.11.2005 08:10:58 OpenForm - WHERE condition I am having trouble opening a form based on the value from a cboListBox on another form. frmClasses contains detailed information about students and their classes. The form navigates from record to record as usual. a cboListBox (cboClassByName) is provided to search for a student name. cboClassByName contains names of students enrolled in all classes. many students are enrolled in a numb... 2 14.11.2005 06:44:58 Printing a report to an Acrobat PDF File Is existing code available that will allow you to output a Microsoft Access Report directly to a pdf file without user intervention? ... 5 14.11.2005 00:50:04 MS-ACCESS.EXE COM Server Remains in Memory after "-2147417851 Automation error. The server threw an exception" Hi, all I am automating Access 2003 (Server) from another Access 2003 DB (Client). Depending upon the existence of some objects in the Server DB, the Client VBA will receive the error: "-2147417851 - Automation error The server threw an exception." I have looked around, and see that this error has cropped up in discussions before. My error handler checks for this error code, and ... 3 12.11.2005 06:45:08 Query same name tables How can I query all the tables with the same name master something like [like master*] (There are master1, master2, master3 etc) and take the recordcount of the query in order to use the recordcount in a for next statement and use currentdb.tabledefs.delete "master" & i (where i the step variable). Thank you in advace kon ... 7 11.11.2005 21:25:06 WinForms in Access Hi, I am new to this... How do I generate window forms in access, so that the users can use it to input/modify the data in the table or database . Basically I want a winform with button on it and when button is click it will generate another winform. And is VB the only language I can use to do this? Thanks aaa ... 2 11.11.2005 17:50:55 Querying Like.. Screwed up and posted to wrong newsgroup. I'm using the LIKE keyword for looking up information in a table in my SQL statement. The problem is when my user enters "Thomas Smith" and the entry in the database is "Thomas A Smith". I'm wondering if there is any simple way around it without having parse the words and write SQL statements after parsing. Any suggestions or links ... 5 10.11.2005 00:40:50 Common Dialog I used to be able to drop a common dialog object onto a form in access to get file/open functionality. That is now missing from the toolbox in access 2003 .. the preferred method seems to be to use the application.filedialog object. However, my code falls over at the first hurdle as dim ab as FileDialog falls over ... Is there a reference that I need to use? Is application.fi... 3 08.11.2005 05:30:23 error in table relation I got this message You cannot add or change a record because a related record is required in table I wonder why I can't this while first when I built the access forms and tables seems to work fine. When I made some changes the above message show up. How can I resolve it. I have a table headmaster and master linked together. I made first a record in headmaster and afterwards I use an sql ... 12 07.11.2005 18:42:42 Get a file name I want to open with VBA the file open dialog box and to use the filename + the path as input in my code. Is there any code in the internet that I can use? Any links or maybe any code to provide me? Thanks In advace Kon ... 2 03.11.2005 20:14:21 Audit trail seperate table??? I got Richard Rensel's modification for MS KB audit trail. Great! But: Trailing is stored in each table's update field. Updating memo fields and copy-pasting changes in the update field (which is a memo field) quickly the update field runs out of space. So I thought of a second approach that would make everyone's life easier. 1) Wouldn't it be better to have a table solely for storing ... 4 02.11.2005 19:58:02 Index, appendix, the whole world.... ISSUE 1: I have two tables with a one-many relationship. I have designed a report with a group header for the one side and the many side spanning to each detail section. something like: p.1 category header: food --------------------- roast beef chicken salad category header: drinks -------------------------- lemonade beer page break (using keep together: whole group) p.2 ... 4 01.11.2005 15:11:34 form's datasheet view Hello all! How much properties of form's datasheet I can use in Access, example selected row, columns or range such as in Excel. Thanks. Stas. ... 2 01.11.2005 11:39:10 Dates - looking for insight Hi all, I've got a text field where someone COULD be putting in a specific date, but not necessarily, and if they do, I want to grab the date they put in. Sounds easy, right? Just use IsDate(). Well, that was all well & good until somebody entered "October 2005". IsDate() picks this up as a valid date when I don't want it to, since it's interpreted by VBA as October 1, 2005, which is... 21 01.11.2005 10:12:31 controlbutton Hello all! How I can create new button in my commandbar with special properties, such as toggle button (example: bold font button in formatting bar). Thanks Stas. ... 2 31.10.2005 19:45:19 Export access tables to sqlserver by code DoCmd.TransferDatabase acExport for exporting a table to sqlserver raises an error while doing the same action manuely (file\export) is doing the job well what is the correct code for this job? tanks ... 2 31.10.2005 16:48:42 17 Pages: 1  2  3  4  5  6  7  8  9  10  11  12  13  14  15  16  17