Search results

Very basic question this (and quite possibly a stupid one). When you have an option group is it usual to have that stored as a Number data type or is it okay to leave it as text type? I ask because on some databases I've seen it's stored as text but I'm thinking that it really ought to be stored...

Oh no. Nothing as advanced as that! Probably not the way to go but what I did in the query grid was have a field when the log was opened, a field that calculated plus 30 working days on the log date, a field with todays date. To extract those over 30 working days (ie, overdue), I took out those...

Finally got it to work!!! Only took the whole morning. Cheers Mile. The way I went about it meant I didn't have to change your code. But hey, the query works!

Cheers as ever Mile-O-Phile. I'll investigate.

Yeah, sorry Mile. Don't know why that is. Anyway, it's the post by Moonshine about 8 threads down titled "Calculate working days"

I'm pulling out logs over 30 days old using <date()-30. The user wants the 30 to be working days. Any ideas how to go about this. I've looked at Mile's thread below but cant quite see how to incorporate it into my needs. Am I on the right track...

Thanks for that. I found that if I had a "requery" taken out then that solved the problem.

I'm running an append query from a form. Works fine. Once I've run it how can I get it to go to the record that I've run it from. It keeps defaulting to the first record?

Cheers for that Wayne. Haven't got the patience to try it out tonite. I'll do it tomorrow after a few beers.

I'm running a report from a form and have a text box which the user types in a word. At the moment I've the following code: DoCmd.OpenReport "Staff Details", acViewPreview, , "[Last name] = '" & [Text4] & "'" This works fine but instead of entering a full word in Text4 I want to insert a Like...

Sorry, should have read: DoCmd.RunCommand acCmdZoomBox (Missed out the .)

Dont know about that or indeed I quite understand your question. Something I came across the other day is if there is alot of text in a text box is to bring up the zoom box by putting this line in the double click event: DoCmdRunCommand acCmdZoomBox

Cheers Fizzio. I'll have a look at that.

Did a search on a thread for this and came up with making the form pop up and modal and works fine particularly as the code option was too complicated. Just one thing, am I right that this also hides the taskbar at the bottom of the screen or have I done something wrong? Not a major problem as...

Mucked around with this a bit more and it works! For Each varItem In Me.List0.ItemsSelected sPerson = sPerson & "," & Me.List0.ItemData(varItem) Next varItem sPerson = Mid(sPerson, 2) ' remove leading comma. sPerson = " [ID] in (" & sPerson & ")"

I'm using this code to pick out items on a list box and create a query. I've only put this bit of code because I think this is where the problem is (hopefully) For Each varItem In Me.List0.ItemsSelected sPerson = sPerson & Me.List0.ItemData(varItem) Next varItem sPerson = " [ID]...

Hi Rich Not sure if you're being serious here. I think I got CTRL P from one of your answers to a previous thread, to bring up the print dialog box.

Funny how offices just wind you up. Spent all day on this trying to block out the constant chatter, some bloke yawning very loudly (with the occasional belch), some woman organising her social life and generally getting mightly pissed off, etc. Solved it within 5 mins of getting home to peace...

Sorry, spent all morning on this but without success. I've a custom report toolbar which I've amended by putting on the CTRL + P icon. This is fine and when I open the db in shift enter the toolbar is fine but whenever I open the database and run the reports the toolbar hasn't picked up on the...

A user had 30 questions all yes/no/don't know and a pop up box to add comments to each question. I had organised it that the user ran an append query which put all the questions into a sub form. Nice. Unfortunately, she now wants to restructure the whole thing and I've no idea how to tackle it...