Search results

Ah, excellent, that looks much neater!

I have a continuous form all laid oout the way I like it. I can navigate forwards and backwards through all of the records. However, the form will always show an extra record at the end (the one with the star in the top left hand corner) where it expects you to add a new record. I am using this...

I have a sub form (frmApts), in continuous view within a parent form (frmDate) that contains appointment data, some of the fields are the 'Team Name' field as well as 'From' and 'To' times. I would like to order first by 'Team Name' and then by 'From' time automatically like in the same way as...

I found this nifty method called 'Space()' that adds 'n' number of spaces to a string or text box, does anyone know if there is an alternate version which can fill in 'n' number of characters of my choosing, i.e. 4 off the letter 'B' or 8 off the character '#'?

I have two Tabs on a form called frmDate the first tab is called PgBookApts the second tab is called PgVisualApts I simply want to display a message box when I click on PgVisualApts, but nothing happens when I enter the code in the OnClick event. I read somewhere that you should write code for...

thankyou for the help, however, I have no idea what it all means :-s

when I used the code; Dim db As DAO.database it caused an error that says; "Compile Error Can't find project of Library" So, within the VBA window, I opened 'Tools'/'References' and clicked "Microsoft DAO 3.6 Object Library" when I ran the code again, it caused an error on the following...

Is it necessary to use; 'Dim rs as Object' before using the; 'Set rs=....' from the code posted above?

where I'm stuck is converting the query above (3 appointments) and visually representing it on one row of 37 boxes. So far, I have only been able to represent one appointment on one row of boxes for each appontment. Record #1 9:00-930 Record #2 10:30-12:00 Record #3 14:30-16:00 So what I want...

Not sure if conditional formatting is the way to go. Here;s the scenario; On a particular day, a salon has has lets say 12 appointments with lets say 4 team members, so for example, to keep things equal, each team member has 3 appointments. A query would create 4 records (one for each team...

for the sample query I submitted, how would it be possible for it to colour boxes on a form from 9:00 through to 9:30 as well as 10:30 through to 12:00 and from14:30 through to 16:00. Normally the form only looks at one row at a time, I want to look at all rows. Thats why I think if there was a...

thanks for the response, but I believe that would only highlight the first record, i.e values 9:00 and 9:30 and not all of the other times too. What I require is a method to either step through each row of a query or somehow load the entire results of the query into an array which I can then...

I have designed a query that returns appointment data for 'n' date and for 'n' team member. Each line of the query has a start time and end time. Each 'time' is represented as one of 37 small boxes on a form. I would like to colour all the boxes between each start and end time for each...

I have some data on a form which works very well. Basicly, I would like to represnt that data by drawing a number of rectangles and altering their position and length with VBA. The number of rectangles can change, so is it possible to maybe draw 'x' many rectangles then alter their shape, or...

I tried; Me.frmProducts.Enabled = False but got an error message that said; "Compile Error: Method or data member not found" heyho, got it working anyway in the end. thanks peeps

I found an alternative solution using a completely differnt syntax which seemed to work;; If chkPaid = -1 Then Me.AllowEdits = False Form_frmProducts.AllowEdits = False Form_frmService.AllowEdits = False Else Me.Form.AllowEdits = True...

Hi, thanks for the response, I am sure the link that you posted is quite meaning ful to someone who is fluent in VBA, hwever, I am a bit of a newbie and am still having trouble understanding the syntax. I looked at the table and tried to adapt the code, but I get an error whn I try to run the...

I have a main form called frmSales and two subforms called frmProducts and frmService. I have managed to lock the main form (frmSales) with; Me.AllowEdits = False however, how do I also lock both the subforms? Thanks, Tricia