Search results

Hey guys!! Real simple question, just can't find my answer anywhere. Form A has a button that opens Form B with filters (that the property is active and that there's a company name). I want it to sort the records in Form B alphabetically. DoCmd.OpenForm stDocName, acNormal, ...

Seems really handy - thank you very much!!

Thank you for taking the time to respond!! Granted the front-end is on everybody's PC, if I make any changes I need to manually update it on their individual computers, yeh?? Is it as easy as replacing the file with the updated one?? That won't lead to corruptness, etc, etc?? I'll probably...

Hey!! I made a database (pretty poorly, in my opinion - but it seems to work) and I'm about to install it on a server for the company I designed it for. I'm looking for some tips on how to go about it since I've never done it before. There COULD be up to 40 computers accessing it at once...

Yep!! I've been using that - just switched to "True" because I thought that was the problem. Ahhhh yes. Ha!! I'm basically mocking myself with the subject line. In any case - again, thank you very much for the help!!

Okay, wow. You know you're tired when: you had [LSActive] on the WHOLE time and wondered why the numbers kept showing up under iif([LSActive]=True,[LSFee],""). GREEEEAT. Thanks for your help - I thought it musta been an amazingly difficult problem since I couldn't figure it out, but really...

Didn't work :( I also tried iif([LSActive]=True,[LS Fee],"") and that didn't work either. Silly Query!!

Hey!! I hope I can explain this well (I also hope I picked a good subject)... I'm working on a database for a company that does landscaping, sweeping, janitorial, etc, etc. I'm trying to make a query to summarize ALL the service information. SO - in some records (sorted by property) there's...

haha... Thank you guys!! That's EXACTLY what I was looking for!! Thank you very much!! Keep up the healthy competition ;)

Hey!! I'm using Access 2000 and I'm exporting queries into Excel. Everything's working fine, but I'd like to change the field names when exporting. For example, in the query a field name is "JAN LS" but I'd like it to just be "JAN" when it's exported. Is there actually a way to do this...

Hello... I'm setting up a database for a property maintenance company that has one "main page" to display the different services with fees, schedule, etc, etc. Included in that mainpage are some basic calculations - adding up service totals for the property - and the like. Today I added...

(and I love exclamation points - I feel I used too many and it devalues them - but I really do appreciate it, I'm just really excited that it's working now)

Fantastic!! That helped a lot and I have it going now!! I really appreciate it!!

Hello!! I'm making a database that primarily uses Codes (eg: CD12, CD81, MILAN01, MILAN02, etc, etc) and I'm wondering: What's the best way to go about making a query to group all the codes beginning with CD, or all the codes beginning with MILAN, etc, etc?? Is there some sort of "Contains"...

Hey!! Thank you very much for taking the time to respond. To be honest with you, I didn't exactly understand your code (haha - not so smart), HOWEVER, in the bottom section, you said to ensure the function and module have different names... I switched the function name and my code started...

Hello!! I have a database for a property maintenance company... There's a combo box called "Freq" (for Frequencies - of which there are 13 different ones), a field called "Total Fee" (how much we're billing the client) and another called "Monthly Total Avg" (it's a hidden field, important for...

That worked great - thank you very much for your help!!

Hey - I'm trying to insert some code that'll be displayed. I want it to say, for example: View Properties (8) (8 being a number added up in a Query) Here's the code I have, it says there's a syntax error. Please help!! [L/S Additional].Caption = "View Properties (", DLookup("[Sum Of L/S...

Jal; Thank you very much for responding. I have a Notes table, yes. I inserted your code but receive a "Compile Error: Syntax Error" for: rs.Open "SELECT * FROM Notes WHERE 1 = 0", CurrentProject.Connection, I looked up stuff about rs.Open, but I can't say understand how it works, so here I...

Effectively, yep. "Notes" has it's own form, so I BELIEVE I need to create a new record in that form, then fill-in the fields as desired. I just don't exactly know the code to do that :(