Search results

Hello!! SEEMS LIKE the Combo Box populates fields if I build it from scratch, but then stops working after closing and re-opening the database. I've been struggling for hours and hours, so hopefully you can help!! COMBO BOX SQL: SELECT Employees.ID, Employees.LastName, Employees.FirstName...

Hello!! I designed a database for a company and installed it, which included splitting the database since upwards of 20 people use it at a time. They recently asked me to add a new feature but MS Access won't let me alter the original table because the database was split. Can I localize the...

Hello!! Here's what I'm trying to do: Make a query that returns results specifically for certain months, separated by county. Here's what I have done: Made it so the counties are separated and they add up the fees if they're active. CC: IIf([PropertyCounty]="Los Angeles" And [SC...

Hello!! I want to add an "Export To Excel" button in a report. When I add the button and go to properties, there are no options for events or data. I'm trying to put the button in the Report Header... Am I doing something wrong or is it impossible?? Thank you!!

Hello there!! I have a form (SearchCode) that's used to search for a "Code" that's chosen from a combo box. When you hit the "Search" button it opens the proper form (Central) and displays the corresponding [Code] which works perfectly fine(!!) - HOWEVER, it also automatically filters it so...

Hello!! I'm building an inefficient database and need your help. There's a field called "Code" that is important to several forms/tables. Because I'm great at setting this up, if I change it in one spot it doesn't automatically update all the others. What I'm trying to do is make a form...

Hello... I need to install Runtime on my machines, which is no problem. What IS the problem is tying it in with the security file. As you know, when you use the security wizard it creates a shortcut that links the password file with the database file with MS Access. Typically it links it to...

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, ...

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...

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...

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...

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"...

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...

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...

Hey!! Hopefully you can help me!! I have a database used to track property maintenance services. I use one form as a "main page" to display each property and what the services performed there (plus prices, etc, etc) are. Also on that page is a Notes form (shown as a datasheet) where notes...

Hey!! I'm building a database for a company that does different property maintenance services, and each property is sorted by Code. For each Code there might be more than one entry for Landscaping, for example. ACF01 - $350 ACF01 - $200 Using a query, I can consolidate that into ACF01 -...