Search results

The option Button is in the Database tools same location you use to add a label or textbox. It is a rectangle with XYZ on the top of the rectangle. In the option you can only have one value for the group.

Brian I agree with you speed decreases with age, or in my case I tend to type fast but end up with spelling errors the becomes teh etc. I have attached a 2003 version of Chris's database. I found a problem when I ran your module there is a field in the output file called Id set to a number...

Brian I am not a youngster. Re Bloating Bloating occurs when you run a procedure and it causes the size of the database to increase in size due to space allocated during the running of the procedure. To reduce the bloat you need to do a Compact and Repair. In my case at work we were running...

I did this process as I am worried about the database may bloat by the reading each input record and writing many records after manipulating the input record. I copied the Split code from Brian's example in an earlier message on this thread as I have not used the Split function before.

Chris and Brian Here is an updated version using Brian's Split coding. I added a third field to the input data and processed in a simialr manner to the second field. Briefly, this is the process 1. Read the input table into an array called array_input 2. Manipulated the array_input using the...

Brian I was not aware that the Split could be used as per your code. Is this correct for the Split function? It splits the string into individual array cells of a single dimenional array based on the delimiter. When you split the plan details you step to every second arraycell because you...

Please post a copy of your database with some sample data. Is the item price included in your invoice, if so why do you need to change it?

Attached is a database that will perform your requirements. There are two tables tbl_input is your sample data, tbl_output is the result of the parsing. I have assumed the following 1. There are two fields in the input 2. The first field is in the format Process number:Name e.g...

I do not have experience in changing the printer's property using code. I manually set the printer to duplex using the printer menu in Windows by selecting the printer and changing the relevant setup.

Here is a copy of some code that was created by Carl Tribble a few years ago. I have added a form called frm_relink so that the user can relink the tables. If the relevant back ends can be found the code automatically relinks the tables. If the backends can not be found a window pops up for...

Thank you. I am glad you were able to solve the problem. Thank you also for giving me the chance to learn a bit more using access.

In your lines of data does each line represent one record or there are more lines of data to make the record? Why I ask is if the field is in the same position for each record on the line of data you could use the MID statement. Here is an example of code that I use to read text ShiftDate =...

Is there code in the On Click or Got Focus of the Date field that populates the field with the date, if so remove the code?

I created one for my department for over 600 employees. This is used as an attendance management system to monitor the number of unscheduled leave e.g. Sick leave, Carer's leave etc. This is the work flow: 1. At the start of each shift each employee signs the attendance sheet. 2. The next day...

It is your Access 2003 database with the latest changes. I used Access 2007 to make the changes. Access 2007 did not convert the database to 2007. I tested the database on my other computer using 2003 and did not have any problems creating new orders.

Put the following as shown in bold Private Sub cmdEdit_Click() Dim stDocName As String Dim strFilter As String Dim stLinkCriteria As String if Preventative_Reqd = true then put stdocname etc to open the form frm_ResultsPreventative else stDocName = "frm_Results" strFilter = "Number= '" &...

Set your default printer to Duplex printing. Then use this code DoCmd.OpenReport strReport acViewNormal I have used this method when I want to print a large report on both sides to save paper etc.

Put NZ in front of the fields in Maximum value: Maximum([field1],[field2],[field3],[field4]) e.g.Maximum value: Maximum(nz([field1]),nz([field2]),nz([field3]),nz([field4])) this will give a value of zero. For the Minimum use the format nz([field1],x) where x would be some high value that would...

Check your table AuthorArticleBr as there is no data to show the author and article.

When I change my layout from Single record to continuous I have no problems. If you are using unbound text boxes to display the employees details e.g. father, monthly salary etc then these will be the same for each record. Please upload your database if you are not using unbound text boxes.