Search results

Had to add an "I"in each If to make IIf() but then it worked. Thanks!

Thanks for the reply. I have been trying to use the IsDate function to test weather it is a date first, but I have never used IsDate in conditional formatting before. If I do IsDate([MyField]) in conditional formatting and set it to green the test works (only the records that are dates show up...

Ugh. I hate asking for help but google isn't solving this one. This DB is connected to a SQL server table. The table is tracking oil samples that have been taken for equipment. The field is data is coming from an IIf() statement and that may be my problem. The reason it is an IIf() is because...

I am yes, i have placed it on my desktop at home and even on my android phone. It syncs between them all but on my phone I prefer evernote or google keep. One note on my laptop has been pretty handy though. I can search past inspections for notes that I took versus opening up a bunch of separate...

I use it. I think its useful. I travel and conduct inspections. I have different notebooks for each type of inspection and different tabs within them for the location it took place. Its faster than using word and keeps everything organized and consolidated.

You can do this: -Combo box on your form with all the Malta Cities -Create a form that allows you to add a city to your [cities in my country] table. On that form include a 'Done' command button. Go to the command button's properties=>events=>add 'on click' event to close the form and an...

Create macro for on focus event of that box. Use 'set property' to change back color? Opposite on loss of focus?

I am sure someone will have a better solution, but you could just keep the form locked down. Create a button labeled 'filter' or something. That button could open a form that is not locked and that contains your combo. Once you select your choice the after update event could refresh the records...

Just leave your query as is. Go to the ribbon and under design click 'totals'. Select 'group on' for all of your columns except the one you are trying to sum. Change that grouping option to 'sum'.

I had the same issue when our office upgraded from Access 2007 to 2013. I had to create a new connection to the SQL Server we were using. The 2007 connection file that was created previously would not connect correctly, not sure exactly why. It was easier for me to create a new connection rather...

Unique values will not work with all the fields you have chosen, because the MR# values are the same, but the rest of the fields are are actually all unique (the dates and such). You can create two queries which might make it easier. Create one [query1] that links table one and table two by MR#...

You could use a continuous or "multiple items" subform to display that data. If you want to limit your result quantity just go into your query and change it to select top (20).

You could build it all in a new query that selects attendees for that event. The on-click event would just print the report based on that new query. You can keep the name bagde report you already made, just change the data source to your new query that selects attendees. Create a query on your...

You could just use a nested IIf statement and do each true individually. Then set the false part as the same "Overhead". IIf([accountnum] Between "60000000" And "60499999", "Material, IIf([accountnum] Between "60510001" and "60809999","Material","Overhead")) AS Assignment

I have ran into a similar issue with importing a spreadsheet. Turns out one of my headers on the worksheet had a hyperlink embedded in it.