Threads Replies Last Post 225 Pages: 1  2  3  4  5  6  7  8  9  10  11  12  13  14  15  16  17  18  19  20  21  22  23  24  25  26  27  28  29  30  >>   Access list box Based on a scheduling database I would like a list box to be populated based on times a certain worker DOES NOT have an appointment. ie: Dave has appointments at 7:15 & 8:00 on the 8th of october. If the secretary goes in to add an appointment, those times should NOT show in the drop down list. I'm pretty new at all of this so indepth answers would be most appreciated...aka write du... 23 21.09.2006 21:32:59 No value given for one or more required parameters I keep getting an error that says, "No value given for one or more required parameters" on the rs.Open line in the code below. The SQL for the query is copied from a query and works great. I cannot figure out the problem. This is a rewrite of some aircode I found on this discussion group. So the main problem is I am working with something I don't fully understand. Your help is greatly ... 3 21.09.2006 21:27:02 date syntax I need to concantenate a date with a time in an insert query: Insert into table1 t (ApptID, ApptTime, ApptTypeID) (SELECT tApptID, dtDate + tApptTime, tApptType FROM table2) What is the syntax for this if dtDate is a variable of type date? Thanks!! sam... 5 21.09.2006 20:20:02 disable alert pop-ups Can someone remind me how to turn off the alert pop-ups such as how many records you're updating on a query, etc.? I can't find it in my code or in the help file. Thank you! -- sam... 2 21.09.2006 20:11:01 Run-time Error '2448' First of all, let me think anyone who is reading this and can provide assistance. I am trying to use this in a form to filter the subform. I have a command button that runs the following code: ' If Assigned To If Not IsNull(Me.AssignedTo) Then 'Create Predicate strWhere = strWhere & " AND " & "Issues.Assigned To = " & Me. AssignedTo & "" End If I thought... 2 21.09.2006 19:31:01 Match names in file and datababase, then send email w/ attachement How do I go through a list of files in a directory, match each of the files names to the names in the ms access table, and then send each match up an email with the file as an attachment?... 2 21.09.2006 19:16:01 oolean variable being changed, but not by code The problem is that a global boolean variable is being changed from true to false, sometimes. We saw it happen three out of 11 tests. It is not being reset by code. How can this happen? The biggest fears is that if the value of one variable can be changed by the "system" then any variable can be changed by the system. Facts. The database references the boolean variable only five tim... 6 21.09.2006 18:41:43 Need Help Running Query My SQL is kind of rusty so I need help running a Query on 4 tables that contain the same information... In the following columns.. SKU Jan Feb Mar April blah blah blah.... What I need is a Query that will take the SKU from table A and the Sales data for each month and summarize it across the 4 tables for each SKU.. With the final output only containing the SKU and the total for each... 3 21.09.2006 18:39:02 Create empty file How can I create an empty .txt file in VBA. Thanks in advance.... 2 21.09.2006 18:25:02 Make and call module I have about 100 forms in datasheet view... How to put this code in module and call from form, in On Current event? Me.[Column1].ColumnWidth = 1016 Me.[Column2].ColumnWidth = 780 Me.[Column3].ColumnWidth = 1950 Thanks!... 8 21.09.2006 18:22:01 excel ole object I have a table with a one saved excel workbook with two sheets as a base table. (I just copied this workbook into this table's ole field). The one sheet is with data and the another one is with a chart. I want to open the chart assigning a new data to the data sheet (from query) so the chart will be changed and save this chart into another users' table with user's records. So, each ind... 3 21.09.2006 17:01:02 Why do I get Invalid Argument just like that after 429 links Everything was going good with a program that I have built and suddenly after entering 429 links to pdf, it started to give me an invalid argument that it doesnt want to save anymore. Is there any reasons? It sais invalid Argument and don't and stops saving everything regarding the program. Got any suggestions?? Thanks... 22 21.09.2006 16:57:44 SP2 problem with SendObject method - Help! Not sure why but the code I've used for a long time is no longer working to send an object through Outlook. It is prompting the end-user to enter their exchange login and password. I've tried some new code using shell script to create an instance of Outlook and it does NOT cause the error, however I'm not sure how to send a report object to the Body or as an Attachment. I have had no luc... 1 21.09.2006 16:11:02 check how many users access the database how can I check how many users are accessing the mdb?... 2 21.09.2006 14:19:30 Tiggers and Constraints I have the following position, in SQL server 2000: Table: Products Table: Orders Table: Order Details Orders and order details are joined thru order id and cascading for update and delete are enabled. Products and Order details are joined thru ItemNo. I have a trigger on orderdetails for delete to update stock in products and everything is working fine. Now if I delete the order from or... 2 21.09.2006 14:18:10 Breaking text into two parts in a report after 13 lines. I need to break the text in my details field into two parts at the end of the 13th line between two words, and place the 2nd part on a differt field on the 2nd page.... 5 21.09.2006 13:12:02 If data is not selected from list, then give an error message I need the code to state that if the user does not select an item from the combo box(which is on the form), then create an error message. For example, the field name is State(which list all the states in the US), if the user does not select or type one of the states, then it will create an error stating, "You must select or type a state from the list" . How can I write VBA code for t... 6 21.09.2006 13:10:02 Location of linked database In VBA how can I find the location of the linked database (there is only one linked database)? My VBA knowledge is not huge. Thanks in advance.... 2 21.09.2006 09:35:37 Using MSChart in Microsoft Access Hi. I've got a query to a database with the id, weight, and height of people. I want to plot a graphic of this data using MSChart. Anybody knows how? Thanks in advance. ... 1 21.09.2006 09:03:02 Outputto question. Hi, I have a listbox that my users select a record from, (the list is made up from a query), once the required record is highlighted, the user can click a button if they want to edit the record, via a form However before the form opens, a snapshot of the record is taken, the problem I am having is the snapshot always uses the first record in the listbox, not the currently selected recor... 1 21.09.2006 09:03:02 working hours counter in Access Good Morning, Well it is Here anyway. I am trying to get a counter to work in access which starts at say 09:00 and stops at 17:00 restarting again the following morning, but not weekends. The counter I have at the moment you will probably find rather crude but hey it works. I have used. Option Explicit Function ElapsedTimeString(dateTimeStart As Date, dateTimeEnd As Date, nameoffor... 1 21.09.2006 08:41:03 Debug - Delete data in Table I tried to run the following code so widely suggested but I get a "Run-time error '424': Object required" message box. I'm a newbie so let me know what I'm doing wrong Function DeleteDataFromDatabase() Current.Db.Execute "DELETE * FROM tblDraftConversionTable", dbFailOnError End Function Los Man ... 2 21.09.2006 07:41:01 recordset I am getting some weird behavior in trying to pull a complex recordset via ADODB. I get an error message "to many line continuations" and the recordset is not pulling all the requested columns. The SQL statement works fine in Query Analyzer. Am I hitting some MS Access limitations? I've got about 20 lines in the query and only around 25 columns. There are nested SQL statements within... 2 21.09.2006 05:23:12 How can I disable the dialogue boxes in MS Access Hi There, I was desiging a report which contain generating report from a table which is being dynamically fed while running the code and in this process i first clear the data in it and then insert the data from the master table. But while deleting and inserting the Access dialogue box is coming warning about the deletion and Insertion. Is there any way to disable the dialogue box from... 2 21.09.2006 03:51:51 access keeps locking up and can't close it down access locks up can't close it down even when using control, alt, delete message comes up say program not responding ... 1 21.09.2006 01:36:01 225 Pages: 1  2  3  4  5  6  7  8  9  10  11  12  13  14  15  16  17  18  19  20  21  22  23  24  25  26  27  28  29  30  >>