Search results for query: *

hi there, For some reason I cannot get this code to work no matter what I tried. I have a table called tblTracker in excel with the columns Name, Start Date and End Date. The table starts on Row 6 (Row 5 are the headers). Column D is the Start Date Column and Column E is the End Date Column...

hi there, We have an accde (Access 2007) db that everyone can open except for one person. She can open accdb files fine but when I tried to open the accde on her computer, it just opens Access (to the general screen - you know, where the db templates are and stuff). We have the security warning...

hi, I'm not quite sure how to make this work (I think I'm close). The paths to the files are stored in cells in Column B. I would like to loop through each row and grab the path and copy the file. So far this is what I have: Dim fso As Object Dim cPath, nPath As String Dim x As Range...

hi, I'm sure this is real simple but I can't figure out why. I am just trying to do a simple IF statement in Excel. Basically, the scenario is: If cell H3 = 0 then put a blank in cell J3. Sounds simple huh? Well, I've put this formula on J3: IF(H3=0,"", H3-I3) But it keeps coming up with: 0...

hi, Just wondering if there is a way to do this in the conditional formatting box. I have a textbox (txt1) in my report that has the following control source: = [field1] & " / " & [field2] which pretty much shows: 1 / 2 3 / 3 etc. How can I set the conditional formatting so that if field1 =...

Is this possible? The report currently looks like this: Col1 Col2 Col3 1 ABC 123 1 ABC 456 1 ABC 123 1 DEF 123 I would like to remove the duplicates so the report looks like: Col1 Col2 Col3 1 ABC 123 DEF 456 So basically group it by Col1 and then...

hi, Is there a more efficient way to do the following: I have 6 queries that are dependent on each other. What I mean is: i need to run the first query to feed the second query and so on. I can run four queries ok but as soon as i get to the fifth one, it says "not enough disk space" and it...

hi, I have the following code in the Workbook Before Save function (in This Workbook). However, it does not seem to be executing.... ANyone know why? If I put it in a macro and run it, it works. But I need it to execute when a user saves the workbook (well, after they save). Private Sub...

I can't seem to get the following to work: Like IIf(([Forms]![frmPR]![chkA])=True,"A","*") Or Like IIf(([Forms]![frmPR]![chkB])=True,"B","*") Or Like IIf(([Forms]![frmPR]![chkC])=True,"C","*") Or Like IIf(([Forms]![frmPR]![chkD)=True,"D","*") frmPR has 4 checkboxes that the user can select...

What's the right syntax for the following: Like IIf(IsNull([Forms]![frmDReport]![cboType]),"*",Is Not Null) I can't get the "Is Not Null" portion to work. Basically, if the user does not select a type in the combo box i want it to display all but if they do not i want it to display everything...

hi, I have several excel spreadsheets that reside on a restricted access drive (for one department only). Some of these files need to be accessed (read-only) by people from other departments. I tried doing Import External data in excel but it wouldn't refresh if they don't have access to the...

hi, What is wrong with my query? Please help. I'm going crazy! I keep getting this error: "You tried to execute a query that doesn't include the specified expression qryTO.MonthDate = [Forms]![frmM]![cbo_Month] as part of an aggregate function" SELECT...

hi, I'm sure this is very simple. I just can't seem to figure it out. I have a listbox with around 500+ items that the user chooses from. I have a button called "Find" that looks for a search string in the listbox (that way the users won't have to scroll through the items to look for...

hi, I don't know if I'm in the right forum for this question. I have an Access database that stores paths for PDF files stored in different folders. The user selects from combo boxes which files to batch print. I have been debugging for a few days now but still cannot figure out why not all pdf...

hi, I don't know what's wrong, or why this is happening. I have a form where a user selects several combo boxes, and then clicks a button. This in turn inserts the user's selections into a table. My problem is this: the code works, but it inserts a blank row before the actual data. It happens...

hi, I'm looking for suggestions/help on how to do this. I have 2 listboxes - List1 and List2. List1 contains a set of data (loaded from a query) with 2 columns - ID and Description. List2 will contain every item the user selects from List1 but it only shows ID's. Here's my problem: I would...

hi, I am not sure as to why this error is happening, since I've used Dlookup before and it hasn't given me any problems. I have a query called qryTotalVPFiles which counts how many VP files there are. In my form, I have a textbox that uses the Dlookup to display this total. The controlsource...

hi, I have the following statement: stSQL = "INSERT INTO tblVendorDeliverableLog(CommodityCode, DiscLetter, TagNumber, DocTypeID) VALUES ('" & Nz(Me![txtCommodityCode], 0) & "', '" & Nz(Me![txtDiscLetter], 0) & "', '" & Nz(Me![txtTagNumber], 0) & "'" CurrentDb.Execute (stSQL) where...

hi, I have a question I'm hoping someone can help me out. I have the following table (in access/excel): Xref Drawing # Tag # VP300-G-1-1 300D-24A VP300-G-1-1 300D-24B VP300-G-1-1 300G-24A VP300-G-1-1 300G-24B VP300-G-103-1 300G-28B VP300-G-103-1 300G-28C .... I would like to somehow...

hi, I've been reading about dynamic stamps and it seems like it's a pretty easy thing to create (I just need a date that changes everyday). However, I am unable to find the directory where the custom stamp has been created. I cannot find the APplication data folder and I tried doing a search in...