Search results for query: *

I get the error: Specify the table containing the records you want to delete. Here’s the SQL: DELETE tblcarrier.Store#, tblcarrier.Request, tblcarrier.Date, tblPkupNoCmp.ACT FROM tblcarrier INNER JOIN tblPkupNoCmp ON tblcarrier.Store# = tblPkupNoCmp.Store# WHERE tblPkupNoCmp.ACT="NoInfo" Or...

I’m trying to use a date add function to pull last weeks data by day e.g. (Monday, etc.) in its current field. Here’s what I tried so far, =DateAdd("y",-7, [mydatefield]). Reiterating:

I need to split this value into two separate fields; 6:00PM [AB-CF], it’s now in one field. The time value needs to be converted into a military value. Any help, please. So, they need to look like this separate by fields. 1. [AB-CF] 2. 6:00PM but this needs to be in military time.

I am filtering a report by date range. At times there’s no data for a particular field when I type in a range, then I get the error, “Jet database engine does not recognize “field” as valid name or expression”. Is there a way could I by pass this even if I filter outside the field range with out...

Hi gang, one of those infamous date conversion issue. I have a time field like 2:44:15 AM. I need to convert this time field into a date field like 1/2/2006. Here's what I've tried so far, CDate([CHGTIME]). -trust

Hi, I'm getting a Run-time type mismatch 13 on this filter code. strSQL = strSQL & "[" & Me("Filter" & intCounter).Tag & "] " _ & " = " & Chr(34) & Me("Filter" & intCounter) & Chr(34) & "" _ And "" Any advice or revision I should used? -Thanks

Hi, Trying to filter a date field, but I'm having trouble. Could someone revise this? Private Sub cmdMonthstotals_Click() On Error GoTo MyErr Dim MyVar As String strFilter = strFilter & "#CHGDATE#=" & Nz(Me![Combo7], "#CHGDATE#") DoCmd.OpenReport "myreport", acViewPreview, strFilter MyExit...

This was originally posted via thread 701-1183479. I should have started it here, sorry. Getting the infamous "type mismatch” as the error.” PHV and dhookum tried but to avail. It happens on the last filter combo box because it's a number value. What should I do? Private Sub...

Hello everyone, could you help me to revise this string filter code. I'm getting a type mismatch because the values are numbers. strFilter = strFilter & "[NBR]=" & Nz("'" + Me![cmbme] + "'", "[NBR]") I need it to filter by number values. -Thanks

I am importing text-delimited data from a note pad. How could I make sure the values are text? I've tried all sorts of expressions but to no avail. Also, some have spaces in them and will not insert or join with another query. I think this only removes spaces: Trim([Field1]). I need to make...

I need to see a value highlighted when it has reached 10:00 AM. I am having trouble formatting it correctly. It would need to be; mm/dd/yy hh:mm:ss. Remember it will be on any given day. Here's what I got so far; If Me![lastdatetime] >= 10:00 AM Then

Could someone revise this Union SQL; I need to match or only see field "jobdatestr" from the table "tblsrvjobCTN" when joined. SELECT jobdatestr, jobdateend, startdatetime, enddatetime, job, jobnum, userid FROM tblnitesCTN; UNION SELECT jobdatestr, jobdateend, startdatetime...

I need to convert the format mm/dd/yyyy hh/mm/ss to just mm/dd/yyyy format and query by paremeter using the format mm/dd/yyyy. But I get the type mismatch error. A little help and example please.

Delete or reset items from an entry form I have a simple questionnaire for users. How can I clear the entries without closing the form? Currently I have a close button which saves the information to the table. Here’s what I got; rst![question3] = Me![opquestion3].Value DoCmd.Close...

I currently use this date serial paremeter to filter by months. The user will select a month like 1-12. But now I can't see anything if I choose a month. Is it because it's a new year? If so how could I modify this to still see last years data and maybe this years data. Between...

OK, When logging on the pc (Gateway XP 2000 Pro) it reboots twice and my documents folder appears what’s the deal and how can this be easily stopped. I have installed the latest anti ad ware and spy ware software still the problem persist, please help. Forgot to mention, make it simple. Thanks...

How could I still show all the records if I leave the parameter box blank when I run a report from a query? thanks

Scriverb, need your advice again. Using this code I have been filtering a report by two combo boxes. The report will not display unless both combo boxes are updated. Now I would like to have either or both combo boxes blank or use as an option if the users want to filter the report. If your...

OK what's the deal? I have created a nice pivot chart using forms, when I want to see it using a command button from another form I see a datasheet format. But does not happen when I click the form along by itself. Could someone tell me what's happening and how could I fix this? Please,

Below is what I have, but when I try to filter the report using the selected text in the combo box, it will not filter. Could someone help me and what I did wrong. Private Sub Command4_Click() On Error GoTo MyErr If IsNull(Me.Combo0) Then MsgBox "No data found! Closing report.", vbCritical...