Search results

Funny, I had to do this in my Running Google Doc recently... :p I'm going to proceed as if your [RunTime] field is text... please advise if that's untrue. If you're pretty sure you won't be running over 59:59 anytime soon, the calculation is pretty simple: RawTime...

Not sure I understand your question, but it sounds like you want WHERE bar=3 AND foo=True

Did you Google it? One of the first results led me to http://www.mrexcel.com/forum/excel-questions/457262-visual-basic-applications-code-do-check-valid-use-computer.html#post2258486

Have you set a breakpoint and stepped through? Sometimes code jumps from one event to another more than you ever expect, and that may be how you're ending up somewhere else...

Only way I ever saw to do this was from the report, not the button calling it. Private Sub Report_Open(Cancel As Integer) DoCmd.Maximize End Sub

CurrentDb.TableDefs("tableName").Connect will get you the string, you'll need to chop it down a bit with Left/Right/Mid to get it to look nice. Mid(CurrentDb.TableDefs("tableName").Connect,InStrRev(CurrentDb.TableDefs("tableName").Connect,"\")+1,99) will get you close.

What happens if you put? DCount("[UserPWD]", "tblUsers", "[UserName]='" & "sampleusername" & "'") into the VBA Immediate window? Any user will do, just make sure that line is working by itself.

In almost all cases Access will treat a query based on a single table the same as it would the table itself. You'll be able to update the non-calculated fields, add and delete records, etc. So I still think you'll save yourself time and energy by putting it in a query. Also if you have to show...

Can you post a stripped-down version of the database with dummy data in it? That might help someone give you answer (like I said, I have no idea how to proceed with that... is the page-break even determined in Access, or in Word?)

Are you using VBA behind the button to open the report? Drop the criteria in your query, it's not flexible enough for this. This is aircode, but something like this should work:IF (IsNull(Me.[Text6]) OR IsNull(Me.[Text8])) Then DoCmd.OpenReport "ReportName",acViewPreview Else...

Or just put the calculated field into your query and use the query (instead of the table) anywhere you need the field+week.

So you're filtering from fields on the report itself? Because I thought you said you were using a form... Anyway, try looking into IsNull(). You can drop that criteria entirely if it's a blank field.

That sounds AWFUL. Without giving an actual answer, would it be faster to just rewrite it as a series of Access reports??

Several other companies are now in the news as well, it wasn't just Target. Why the US still has such lax security astonishes me... but then not really.

Are you CERTAIN it will be the most recent record insertion? What if you have more than one user in the system that day? Anyway, sounds like you need to add an additional criterion that identifies that most recent record for the system, and spits out that record every time. It'll probably be...

I concur, if it's only going to be updated every so often, you will find your life much simpler with an imported version. There's probably code out there to check and see if it's been updated, and import it automatically on boot that day, but that may be more trouble than it's worth. Heck, do...

What error message are they getting? I frequently hit an error message (in Excel) if I have the sheet open as a linked table in Access (or ArcGIS, or...). But sometimes if you've got it open in Excel, they won't be able to open it in Access as well. It's tricky. Do they really need to update...

Please list any fields you have that end in 1, 2, 3, 4, etc. Or upload a screencapture of your table Design window. Access is NOT a spreadsheet.

What are your fields? I'll bet you even money that you need to normalize your database, rather than split your table in half. Google it or search the forums.

DoCmd.OutputTo will be your friend here... depending on whether you want Excel, PDF, whatever for the output. When you say the 'output' of two tables, do you mean a query? You can use a variety of methods to get the number of rows (DCount is easiest, but slow), and if it's 0, don't even bother...