Search results

Hi, been reading this thread and I'm hoping to secure my database simply to distribute, so users can't access the code behind forms or change any designs. I can't make it into MDE as I'm using Access 2003 and some of my users will be using 2000. I read this solution in an Access book, but...

Thanks guys, i ended up copying everything piece by piece to a new blank db.

Hope you can help guys. Here's what happened. I saved a form as a different name so that I could work on it. I made some changes to the new saved form then tried to save it to the name of the old form, to overwrite it. It came up with an overwrite warning, i said yes and suddenly the database...

I ended up creating the sum in a query. This worked the way I wanted. thanks

I'm pretty new to reporting in Access so please bear with me;) The report I have created consists of the report header and footer, 2 catagory headers and the page footer. I have some info in one of the catagory headers that I would like to total for the report. I have used =Sum([curPrice]) in...

Oh, I see, thank you

Me.tblCustomers_chrWorkgroup is the name of a textbox within the form, so not a string.

Hi, hope you can help with this problem. Here's the code to open a recordset. Dim rsWorkgroups As New ADODB.Recordset Dim SQLStmt As String SQLStmt = "SELECT * FROM tblWorkgroups WHERE chrWorkgroupName = " & Me.tblCustomers_chrWorkgroup rsWorkgroups.Open SQLStmt, CurrentProject.Connection...

Your question is a bit odd as you bind controls to tables and queries not buttons. If you mean can you print whatevers in the textbox when you click a button, then yes you could although I don't know why you would want to print just 1 textbox. Could you clarify what you're trying to do? Carl

Solved :) Actually, i solved this problem now, thanks. I created a new calculated field within the query that the form was bound to and used that field as the Job price. As it is a calculated field, it won't update to the table. Slowly getting there :)

Every job has a set monthly price, but sometimes extra work is done on the job so the price is increased just once. So, i'm retrieving the set job price, which is "txtCustomerPrice". I don't want to edit that textbox if it is more as that will change the set monthly price for that customer...

Hi all, I'm hoping there is a simple solution to this one. To keep it simple, I have a continuous form showing a list of records. I have added an unbound textbox to this list. I would like to copy the value of one of the fields for each record and paste it into the corresponding unbound...

In the form properties there is one called "allow additions". Set that to "No" and that should disappear.

Have you tried saving the form as a report, then printing it?

I'll try the listbox solution Paul. I haven't used list boxes very much so I can't really "see" the solution, so i'll just have to play around with it and hopefully I can get it to do what I'm looking for. Thanks again.

Yes Paul, you're right. I've tried form/subform, but that doesn't work for new data. What I'm gonna have to do is create a form with the customers table, then place unbound check boxes for each customer with code to create a new entry in the jobs table for each customer that is marked as done...

True, I do tend to complicate things, sorry

Thanks Banana, I think I know what you mean. I'll give it a try :)

If by manipulate you mean edit, then yes, you can. Simply click in and type.

I'm not sure you understand what I'm looking for. I need to be able to see all the customers at once and update them. I've included a file to show you what I mean. Just click on the "update record" button to open the form. As you will see, only one customer will show. thanks for your help Carl