Search results

Create a query. Put all those fields inside it including the filters (WHERE...) you can order [fornavn] from the query. In the query columns for "3" and "C" put that code in where field is. Hope this screeny describes that in visual detail. When that's created and working, set the record...

Take a screeny and make the file yourself?

I've managed 2 seperate properties in subforms... i assume as they're 2 seperate forms then it shouldn't matter.

I think if you put it in every subform, then when you open the form they should all get to 30 seconds at the same time. To be perfectly honest with you i've never used timers for a form with subforms, but logically, this should work. just click those three dots in the event tab and you're away...

Private Sub Form_Timer() me.refresh End Sub That should work... Do you get an error at all or does it just not want to work?

Set every forms timer individually. They should all be in sync when you open the main form. timer interval would be... er... 30000? it works in thousandths doesn't it?

Hello... again... I'm having a problem with what looks like a form refresh. My form has a single drop down box, when that's updated, the whole form is visable and resized etc. Depending on the criteria in the dropdown box, up to 20 text boxes are updated using a DLookUp. Everytime something...

Best bet would be to create a query and have the expression: Expr1: IIf([Column]="Yes","X",Null) Then use the query as the source for the listbox. I hope i've understood correctly.

I did try this, however i could only get my query to show the percentages for regions, and not the company as a national. I couldn't calculate the percentage nationaly in the way i did before, because none of the original info was in the query because of this change.

Hello, I'm having a problem with grouping and sorting that seems to make my report wrong. I have a report grouped by company name and then region name. All Regions need to be above 70%, if all regions are above 70% then the company name and the regions for that company shouldn't be on the...

Hello, Is it possible to load a list of references via code? My problem is that when i update my application (which refers to Office 2003) my users get "MISSING" on a few references. I understand there is no way for the program to update its own references with whatever's on the user's...

Although it's a read only database for your users, this can still create a masive amount of server load with roughly 25 users sending queries back and forth. It can also corrupt the database (although i'm not sure if it would as Read-only). I strongly suggest reading through this thread and...

I'm having the same problem. But my references are because of the file location of Microsoft Office. I'm using 2003 (Version 11, thus .../office11/excel.exe), and a lot of my users are using 2002 or lower (Version 10, thus .../office10/excel.exe). It's rather annoying having to spend about an...

Just wanna say thanks for the help with this. I've set it up and it's working fine if the user has Office 2003 (Office11), as the database uses Excel for data exports, Word for mailmerging and Outlook for emailing. If the user doesn't have the same version, the VB references complain bitterly...

I've been looking more into this and i found the Right([field], length) function. As the memo field varies in length significantly, it might not be the best function to use, but is there code i could put in the function to get only the top line of the memo? Perhaps if i have less to work with...

i want the first character in the last line of the string. once i have that number i can add a button in my form to add a new note on a new line.

i read through the msdn tutorial for the DMax and DMin function, and i don't think they are what i'm looking for. All of the notes are in the same field. It's not a sub-table.

Hello, I'm incharge of development on our access database at work and i've progressed from hardly any knowledge of access to what our database creater explains as "advanced". I disagree, because there's still so much i don't know yet. Anyway... We have a notes field for every record in our...