Search results

And the best thing about Stophers suggestion (which is right of course) is that designing a Form would be very straightforward and would look almost exactly like the paperform you're using now. So the database will look and feel real friendly

Do you want to split the Field2 into all it's pieces either side of a space bar, then reassemble them with a + sign intead of a space? I'm thinking ParseWord() Function. http://allenbrowne.com/func-10.html

Have I got this right? the first part of a URL is stored in one place and is always the same. the second part of the same URL is stored somewhere else. you want to link the two parts into one Hyperlink?

When I first started out in access, I thought it was okay to have LookUps in Tables because Access lets you do that - and it must know what it's doing - I thought(wrongly!). Since being on this forum, you chaps have put me straight on that.

Dave – you have very made my day THANK YOU For the benefit of anyone following – here’s what I did to get a sum of seconds in a query to appear as an amount of time – like 2 hours 20 minutes. Table1 has a PKField and Field1. Field1 contains a number representing seconds. There is only 1...

Thank you Gemma-the-husky. Mod looks like the right answer - Will report back when I know more. Sorry I've not put up sample data Plog - it's a reasonable request - and you asked me twice! But my Objects don't have simple names like Table1, Query1. I was afraid of hiding my question in a sea...

Sorry Plog. Thanks for answering. Didn't want to witter on. Table1 has a PK field (autonumber of course) and a Number field which holds a number representing seconds. There is only 1 record in Table1. Table2 has a FK related to Table1 so that all records in Table 2 have the number of seconds...

Field1 is a number representing seconds. After multiplying Feild1, I want my result to look like, say; 2 hours 20 minutes I imagine Field2 counts number of times the result gets to 3600 for Hours and Field3 counts the remaining number times the result reaches 60, (I'll ignore the...

Thank you Pat - you've done it again. Here's what I did for the benefit of anyone following. In the OnCurrent Event of Form0 I wrote Private Sub Form_Current() If Me.WWWAddr & "" = "" Then Me.Command0.Enabled = False Else Me.Command0.Enabled = True End If End Sub What happens now is...

Table1 has the booking times with Field BookingDate which is the dates of the bookings you already have. Query1 gets data from Table1 and looks like this (each block text below represents a column) Field BookingDate Table Query1 Total Group By Sort Ascending Field Day of the Week...

Thank you Pat - I did exactly what you said - it works great! Here's what I did if anyone is interested. TextBox1 contains a Hyperlink (that's unique to each Record). But, I want a Button instead of a Text Box - because it'll look nicer. As Pat suggested, I looked up "FollowHyperlink Method"...

You need to know if a particular time is already booked before entering a booking time to your database. Otherwise, the Conflicting Entry MsgBox will pop up everytime to you stab in a conflicting time, until one (eventually) sticks. So, I imagine, you might have a Form set Continuous showing...

The link doesn't quite solve the problem - but it took me near enough to find the rest of the way. Here's what I did for the benefit of anyone else reading this. I want to open Form1 from an OnClick event in Form0 and filter by date. The Wizard SEEMS to write the VBA for me BUT DOESN'T...

Yes - it looks like it will, I'll have a read through and see how I go. Thank you for such a quick answer.

May I ask your help with this one please? My Form0 has a Field called DueDate in Short Date Format (I’m in the UK). When I click DueDate, I want to open Form1 filtered to DueDate dates. But I get mixed results. Either the records returned have month and day are reversed or I get no records...

Thank you for your answer Pat, but my list of Format options for a Text Box is different to a Button - so I can't make it look even close! How about a Button which fires the Hyperlink Field? Is that a daft idea? What might be the VBA for that?

May I ask, how can I make a Hyperlink Button on my Form? Of course, my records have a Hyperlink Field. Adding a Hyperlink Field to my Form works fine, but it doesn't look right. Instead I want a button without the http://www... text written in it. I looked at the Hyperlink Field's "On...

Your method gave me some really good ideas - thank you very much indeed.

Yes it's straightforward What are the field lengths of the original fields? I'll have a go at answering this one.

Thank you very much JBB, I'll play with what you've given me and report back how it goes.