Search results

Hi there. Was wondering if anyone could tell me if it is possible to get rid of the horrible little "X" in the top right hand corner of the Access App? I know how to hide it in a form, but need to hide it on the app itself. This would force end-users to actually use the Close App button...

Hello all! I am using the CopyObject method in the event procedure of a command button to make a copy of the underlying table. I'd like to be able to date stamp the new Tblname with the current date. Effectively, every day that work is assigned, the assigned case load for that day would be...

Ok, I know that Access can be a little flaky at times, but this one deserves to be put out there! Could someone take a look at this error that I am receiving and tell me what they know? I am building a make tbl query that only has two fields: cakes|countofcakes when I try to run it as a make...

This has got to be sooooo simple!!!! I just can't get it figured out. Tbl stores all "requests for service" and "date requested" Turn around time on filling request is 5 business days. I need to query on requested date and bring back only those that were requested 5 days ago or more...

Ok, here we go.... Have a tbl that has multiple line items for one acct. Acct No. 30 day bal 60 day 90 day 457 $2.57 $5.93 $0.00 457 $0.00 $6.23 $10.01 457 $15.17 $5.93 $11.25 457 $0.00 $0.00 $0.00 And here's the...

Ok, here we go. I have an main form that pulls up general case info by case id (unique value) It has a subform that brings all accounts and acct info (from another tbl)related to each id. Each case could have multiple accounts. Each account has a balance. On the main form, I need to be able...

Ok-let me see if I can explain this.... I have a report with 4 sub reports on it, each one counting the same field on a table, but with different criteria. ie..there are four different types of fruit that I must count. So, I have a separate count query for each type of fruit. (is there an...

I have a list box which uses a parameter query to bring back all matching results of the search. ie.."Search by last name" would bring back all cases with Smith as last name and display them in the list box. How can I then select the particular case I would like to view and bring it up in edit...

I have a multiuser database on our WAN here at work. I am wondering if anyone could help me out on autopopulating the user id on a form, thus writing it to the table. I have heard that this can be done when you have a user work group in place, but the example db that I have to go by gives no...

All- I am using the send object function in a macro. Does anyone know if it is possible to send more than one file in that same e-mail?

I need to place calculated fields in the report footer of the main report that use fields from the subreport for the calculation. The logical way to do this would be to simply create calculated fields in the footer and write the expression using the desired fields from the subreport. However...

I am stumped on this one! Situation: Main form [Case Info] has subform [Acct Info] In [Acct Info] I need to calculate cycle time and have it write to the table. formula =[Date Stopped]-[Date Acct Est] I have created a macro on the subform that is used as an after update event for the Date...