Recent content by Malashaan

Yes, the precise time that it fills the autonumber field is still unreliable - it seems the only sure way of setting it is for one of the other fields to have data entered.

You could try replacing the "like *" in the IsNull clauses with " Like '%'". * isn't a wildcard in SQL like it is in Microsoft OS and it looks from your code like you want a wildcard, which in this case would be the % character.

Thanks for the suggestion, it does work but doesn't fit how the guy I'm making this for wants to use it. I've taken some of the automation off to force him to enter at least one bit of data on the sub form by hand even if he wants values. Sometimes users need to be less lazy ;)

It is a data entry form but pretty much every field autofills a default value on creation. The new record is created from the main form. I could just take the default value off the main list box on the subform and force the user to select something, but he (the user) is very particular about...

I have a sub form which is linked to the main form by an autonumber field, JobID. Both froms get their data from separate queries. Using this as a unique identifier I thus have the same single record visible in both forms at any given time, this is working great. However, when a new record is...

I had a moment of inspiration and figured out a way to achieve what I wanted without using the TextWidth function at all. Rather than have a separate text box for the dots I make the object with actual data from the query not visible and have a text box running from the right edge of the data...

I'm trying to get report data in the format Cut........................ Oval Cut........... Brilliant Round Cut......................Square ie, whatever the value for the record which is printed the title will be left aligned and the value right aligned with period characters filling the gap...

Transparent, the dots appear through the right hand edge of it - they just stop REALLY early. If you move the dots field out of vertical alignment I can see that they are indeed stopping. The length of the line (me.line17...etc.) confirms the place the dots are stopping is consistent with the...

Sure, no problem. I've attached the relevant code I'm using too. I would have done this last night but I'd been up all night and apparently wasn't thinking straight by that point :eek: Option Compare Database Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer) Dim blErr As...

I'm using TextWidth to format a report but it doesn't seem to be returning accurate results. To test what was going on I added the following code which should place the object TestLine lined up the text and set its length to the width of the text, essentially an underline. Me.TestLine.Left =...

Thanks for the Lebans link. It's pretty similar to what I was starting to build. It revealed to me the existence of the TextWidth method which I'd managed to totally overlook the existence of :-/ All working now to a passable level. I've noticed something a little odd which is bugging me. I've...

Unless I'm missing something that line objects can do this won't work. The key behaviour I need is that the length of the line needs to adjust itself at runtime so that it exactly fills the space between the label and the data field. Ie, something like this: Record1...

I'm trying to lay out my report data something like the following: Length........................25mm Width........................120mm Depth.........................10mm Finish Colour.................Black I thought this would be straight forward enough but I've got completely stumped by it...

Thanks. So what I'm trying to figure out is what the "good practice" way to code a form which autofills details from a second table is. As I understand it the main table shouldn't have the city and state information because they are entirely dependent on the ZIP code. For the same reason it...

Here's a simple example of the behaviour I'm interested in. If one enters a ZIP code (one of the 4 I've included in the ZIP codes table anyway) the City and State autofill. I can't quite get my head round exactly what's causing the autofill. It's probably obvious and I've been looking at it too...