Search results for query: *

Hello TekTips .. been a while. I was hoping someone could help me with this query. I just need to return only the rows boxed in green. It's basically the most recent date ONLY for each suc_pic. I think I need a subquery I just don't know how to structure it or where to structure it. Any...

Hi All! I'm pretty sure this is possible, although I'm having trouble getting started. If you look at my screen in the link, I want to compare the time in the record with the time in the record just after it (log_id + 1) and then do a TIMEDIFF (if such a function exists to get the number of...

All- Having some trouble. Trying to write a VBScript that will delete a worksheet from an Excel file. Sounds simple enough but I can't get this to work. I figured I would pass the xls name as arg1 and the worksheet name as arg2. Also, I don't want to be prompted since I am going to run this...

Hello all! Not sure how I write my query to get the following... If you see the attached screen, you'll see that I occassionally am getting the same UPC twice because my Item Desc is slightly different (typos) so my Group By is generating 2 records. I want to use a Count (which I'm doing in...

Hello everyone! My issue: My query executes fine but is very slow. I'm trying to understand if there is another way I could structure it to be more efficient. I am using Access 2003. My query: SELECT a.InvcDte, a.CustomerId, a.ItemId, b.PkgSalesSupvId, b.DftSalesSupvId, b.PkgSalesRepId...

I don't understand what I'm doing wrong here. My DIVS will not display in IE or FF. Can anyone help me understand what I'm doing wrong? I recently switched my doc type to xhtml. Thanks in advance. greg ps. sorry about the cut and paste of code, no server to host this on right now...

I'm not sure if it's possible, but here is what I'm trying to do... I have t_fact_pops table which contains records of pops. In this table, I have fields Expected and Available (among others). When a pop is expected but not available, no record is created in this table. So, in this table all...

I'm trying to convert a date stored as an INT into a DATETIME format. For example, my date is formatted as 20071231 and I want to convert it to a proper DATETIME or SMALLDATETIME. Anyone know how would I go about doing this? I searched the forum and Google'ed this, but have not had much luck...

Hello all. I need an extra set of eyes if someone is willing to have a look. 'targetitem' is null or not an object in IE when I view a page I am developing. I can't figure out why I'm getting it. The JS works fine in FF, altough visually my page needs work is FF...

I had to import several extremely large, comma delimited text files into my SQL Server db. I didn't notice at first, but all my fields are VarChars of size 8000! Most all of my fields do not exceed 30 in length, and I want to redefine them all as nChar of size 30. Is there an easy way to do...

What is the easier way to code a CRLF for my Text82_KeyDown Event? I want to be able to move to the next line of my text box if the user hits return(instead of leaving the text box which it currently does). Kindof like the function of the CTRL+ENTER if i do this in the text box now. Any ideas?

Hello all, What is the best way to programmatically set my Record Source(on the Data tab of my form) to the Name of the Form itself?(I will also have a table with the same name as the Form which is what I will really be using as my Record Source) Can I just code this in the Data tab, or do I...

Oddly enough, it seems all my Forms have stopped working properly. When I try to open each, I get an error "There is no object in this control" followed by the error "Error No: 438; Object Doesn't Support this Property or Method." All forms use the ListView control, but thats really about it...

Is this a basic question? I want to programatically create a text label on my form with the actual name of the Form. Anybody done this? Any assistance would be appreciated. This is Access 2003.

I'm stuck again. This is VBA in Access 2003. I am trying to check to see if a FORM exists in my db. My code here to check to see if a TABLE exists works, however, I don't know how to check for a FORM. Is there a FormDefs (like TableDefs) that I'm not aware of? Thanks to anyone in advance...

Can anyone assist with this? I don't know how to code this in VBA. I want to copy an existing Form (which I have the name of) and rename the copy to something else. I want to do this with a Command button in my form. Any comments are appreciated. This is Access 2003. Thanks.

I recently had to format my HD and start over from scratch. I have since been trying to get everything back up and working on my machine. Today I installed .NET and Access 2003, and after doing this, I tried to open a VBA project I had been working on. I get the following error...

http://beckwiga.homeip.net/example.bmp In my ListView, if I click on an Item in the ListView (but not a subitem), it gives me the option to edit it. I want to turn this off but don't know how. If I set Enabled in the Data tab of my LstView properties, the ListView does not populate. I am...

Here's another one I can't figure out... I have a ListView on my form. I want to be able to select a row in the ListView, and upon doing so, I want the rest of my form to goto that record id. For example, my Listview consists of Name, City, State. I have other fields on my form, also Name...

Something is wrong with the syntax of my UPDATE SQL here. Being prompted to enter parameter values when I execute. VBA syntax syntax is still new to me. Anyone assist? Private Sub Zip_AfterUpdate() Dim strSQL1 As String Dim strSQL2 As String Forms!Address.Refresh...