Search results

Thanks David that did work!!!

Hello, I am creating an application for my boss, its a database that keeps track of workorders by fiscal year. Its there any way that I can create a code where at the end of the fiscal year it saves all the information for that year and strat from scratch again but with the new fical year on...

Alright!!!!!! I got it!!!!!! It took me all day but I GOT IT!!!!!!

Thanks but am still having problems, I dont understand what event am suppose to use so that when ever I have a check box selected and I look at that record it will do something if the that checkbox is checked. The problem is when I want to view the records on the form and go through them. The...

Hello, I have 3 chkboxes that when the value of one is true, I get new feilds to enter data, and if one of the other chkBox is value becomes true then the first goes false and other types of data entry fields appear. Now when I save a record the value of the chkbox that was picked stays true...

Thanks I cant believe it was that easy.. I guess sometimes we need to step back and take a break!!!! thanks a lot.. Dani

I am trying to make a code for an Option group so that when the option button is selected it makes certian comoboxes visible=false. I did this but it does not work. I cant remember how to do it. Please help Daniel This is what i did Private Sub frmSearch_BeforeUpdate(Cancel As Integer) If...

Thanks, yes I tried a couple of ways but always comes up with the subform. Ok, this is what I have, two tables, tblCustomers and tblAddress. I want to be able to enter the customer information "Fname,Lname,Hphone,Wphone" and the address information "Address, City, State, Zip" all in one single...

Hello, I am trying to make a form from two queries, but I dont want it to have a subform. Every time I try to do it, I cant make it so is just one form with out a subform. If there is anyone out there that I could call to explain what I need to do, please send me your phone number and I'll call...

ok, i did it with the nodata event. now am actualy opening the report from a code on a form button, the code I used for this was the next one: Private Sub TestNoData_Click() On Error Resume Next DoCmd.OpenReport "SomeReport", acViewPreview If Err = 2501 Then Err.Clear End Sub But I...

Hello, I have some reports that I need printed only when there is data for them. Right now when I print a report, it prints the reports labels with no data in it. How could I fix this problem so that I will only print when there is data for that report. Thanks Daniel

Hello guys, I have a problem and can't figure it out!! I have a small workorder database,I am printing the workorder forms as report. Each report come from 3 different queries. On the dataentry form you can choose from three options of what type of workorder it is, New Construction, Cart...

Hey guys, Never mind!! I dont know what I was thinking!!! Is a simple update query!! thanks

Hello!! I have a small database, its about workorders. I print out workorders forms as reports, I have a checkbox on the workorder entry form that says Printed? "for internal use only" with the default value to false, I want to be able to Print the report that is based on a query that only the...