Search results

I do need to pull the date range so yes I would like to make it prompt just for the date range. No the dates could change but the time wont. This report will always be for records entered between 1700hrs and 0700hrs No irregular patterns

I have a report that I need to pull records for time range. I am using Crystal XI incident.date = date&time dd/mm/yy hh:mm:ss incident.date holds both the date and timestamp of the record. I need the formula to look in the incident.date field and then look at the time stamp in 24hr time and...

I have a query that needs a calculation field for a report. This is my field in the query. Gross: [TBLinvamt]-[TBLinvqty]*67-[TBLfrtamt]-[TBLocamt] Here lies the problem example: 3210.81 - 25 * 67 - 0.00 - 0.00 If the frtamt and ocamt fields are 0.00 then my Gross field does not display...

I have a table called tbltechissues that has a field called problem that is a combo box. I placed that field on the form and set the multi select to simple, but i need to pass the selected data to the field into the table. can someone assit me in this process Thanks

I have a small database that will have a button on a form. That button will run a query that I have setup and working. The quesry just prompts for a date then returns data for that date range. that all works fine but once I have th datasheet view I want to be able to modify a record from there...

That worked great, So I just need to rememeber to redue the same calc in the second calculation Thanks

I have 2 calculations in a single query. 1st - ProdCost: [TBLinvqty]*67 2nd - Gross: [TBLinvamt]-[ProdCost]-[TBLfrtamt]-[TBLocamt] The query runs and works fine but it keeps prompting me for ProdCost but if I hit ok it runs fine. How do I get it to quit prompting me for Prodcost BTW...

Can I use the Macro Requery or do I need to write and expression code for this.

I have a frmCustomer as a main form with a subformOrders as a sub form. I now want to add another subform that is based on a query I build. I only want that subform to refresh (update totals) when data is entered in the subformOrders fields. I am trying to use the TimeInterval, I created a macro...

I have a small db with a form and a subform When data is added to the subform, i need a little warning light that tells my user that they have exceded the max amount for that day. Example: Fields in Subform schedshipdate deliverydate qty pkgwt pounds this is a calculate field (=[Qty]*[pkgwt])...

Paul, I have another question thats been killing me. I have a smal DB. How can I send the app to you to look at to see what I am doing wrong in getting a combo box to lookup a name from a table and populate the address then have that data saved to another table that is all part of the order. Dean

Thats what I thought , I could not get it to work so I wanted to make sure it is impossible to do

Is there a way to have a Criteria set to promt a user to select a item from a dropdown list. So when the prompt is made to ask for the Item Name it will have a dropdown list that the user can choose from

I got the other fields to work now, But heres the problem. If I am in record # 4 and I select a company name and it populates the address, when I switch to the next record that same name and address is in the fields. So then when I change it in record 5 and go back to rec 4 the info changed to...

whooops spelling John Doe

So when I select joen doe from the tblBilltoCustomer it will dispaly John Doe 102 Commerce St City , State , Zip

Ok, I understand that, but on my form I want to have the following CustomerName ( Lookup box form tblBilltoCustomer) Address 1 (form tblBilltoCustomer) City (from tblBilltoCustomer) etc......... How ho I get the other feilds. Do I put an unbouded text box on the form for the rest of the data

I have a small database with 3 tables. tblBilltoCustomer Fields - Key - BillCustID , companyname, address1, address2, city, state tblOrders tblCustomers I have a form that has tblCustomers as the main form then tblOrders as a sub form. I want to place a combo box on the form that will...

Me!SystemUsername = Environ Is this correct ?

No but i will thks Is there any other way of grabbing the user info from the windows pc they are logged in without getting to complicated ? Like i said the date works fine it just need to bring in the user that is in that database at that time