Search results for query: *

Hi all I am having a problem getting this code to work. What I want to do is on a form (frmI) I want user to check a checkbox on each row (continuous form) and then click a command button and auto insert some information, then create a word document for that record, then save the word doc...

Hello All I am trying to format an number (long integer) into text to send an automated email from Access. I have the format in the table and am able to get this format to work everywhere but when I try to format the number while sending email. so the number is 1 (no leading zeros), when...

Hi all I have textbox on a form that is numeric data type. I am trying to have data validation instead of the ms Access error message for this field. I have tried everything, even adding a new textbox. I have deleted format "general number", default value, and for some reason cannot figure...

Hello All I have a form (frmNCOE from tbl1) that has a combo box with a record source coming from tbl2 - (item list), that has 4 fields that show in the combo box, then based on the choice the user makes auto populates the combo box, plus the 3 other combo boxes. (This all works fine) When an...

Hi All What I want to do is to open a form in database1 from database2 and passing one numeric field into database1 form. I have the form in the database1 opening from database2 with the following code: Dim acc As Access.Application Dim db As DAO.Database Dim strDbName As...

Hello I have a main form (frmECNOE) that has one subform (subfrmECNDE). I am trying to send two different emails, based on whether ImpactYN field is true (This field is in the subform) First the code is sending to all, instead of testing for True value in field ImpactYN. Second when first...

Hi All I have a main form that has a sub form on it. I want to have the user enter the main form and when they enter main form or sub form, automatically add 5 new records in the sub form with one of the fields filled out. Would it be better to add when entering the main form or wait till the...

Hello I am trying to do the following in excel: 1. test 2 cells for null value (should contain date) 2. After testing both cells for null use networkdays to figure the amount of dates between Here is the statements i have tried to no avail: =IF(ISBLANK(G857:H857), 0, NETWORKDAYS(G857,H857))...

Hi I am new to Crystal Reports. I am wondering if the following is possible (i do it all the time in MS Access) On a report i want to check to see if the default date is 1/1/1900 if it is on the report i want it to show as "None". I have tried different IIF statements i do not believe this...

Hello All I have done a little research and am wondering which would be best for the following scenario. I have multiple users coming into a database to add a change notification. The “Unique” identifier is to be formatted to 9999-9. This is numeric, first 4 numbers are a work order number...

I would like to change the list items in "Locations" within the web part "whereabouts" i cannot find any information at all about how to do it. Any information at all is greatly appreciated! Raven

Hello all I am trying to query one field with a AND statement. It is not working. Here is my sql statement: SELECT tblData.sonum, tblData.wsnum, tbl.Customer, tblDetails.itemdesc, tblSDetails.itemqty, tblDetails.itemnum FROM tblData INNER JOIN tblSDetails ON tblData.sonum = tblDetails.sonum...

Hello all I am having a bit of a problem with this line of code. I have a form that users input information and it produces a dynamic query. The like statement for the memo field is not working at all. where = where & " AND [specialcircum] like " * " & " + Me![spcircum] + " & " * "" and...

hello all I have the following code, for some reason it will not go to the last folder. When button is clicked it goes to the Applications folder. I have tried a few different things and searched thru this forum and cannot find a solution. This should be simple but my brain hurts - i know...

I have a report grouped by week number. It all works fine. I want to have this report only show the current week number and the 3 following weeks. The report is based on a query.

Hello All I have a form that when it opens what the user sees is the middle of a listbox a quarter of the way down on form. It should show a date at top left corner. the form is based on a query. I am stumped any help would be appreciated. Thanks Raven

Hello All I have a listbox that I am trying to get the total $$ for a week from. I can total all of the records that appear in the listbox fine but when I total based on the week number it goes thru the code, and gets to IF statement and then even when the IF statement is true it skips over...

Hello all I have a report that groups Sales orders by week due. Now they want this information displayed in an editable form. The same way it displays on the report and i am having trouble getting this to display correctly. I am using two tables - tblorder and tblitems I am using a due date...

I have been recieving alert logs from SonicWall firewall appliance. In them i am recieving two kinds of alerts that are alarming and wondering if one of experts can give me some advice: 1) 07/31/2009 09:32:54.240 - Possible port scan dropped - 192.221.96.126, 80, WAN - 209.195.155.48...

Hello All, I am trying to get some information to auto insert into a memo field BEFORE the user enters information. It works except now they want to choose if they want the info to insert before entering. I added a msgbox to the code, and it works, but now if the memo field is null it puts...