Search results

I have tried that and nothing happens. Apparently it is because I am using Access 2013 and the Environ stopped working as early as Access 2007 (or 2010).

This is what I have done so far. I have my tblImagePath with a field LoginID After I login to my DB and login, I open the table and see the username in the field. I go to my form and put in =[tblImagePath]![LoginID] as the default value. when I open the form, I get the #NAME? error.

In my current process, when the user opens the database, they are presented with a login screen, from which they select their name. This login determines which menu they will see while using the database. The USERID is a shortened version of their name (firstinitiallastname). In one of my...

I have partially figured out how to record a username into a table used during logging into the database. I now want to get the contents of that field (LoginID) from the table (tblImagePath) in a textbox in another form. Can't I just reference the field using [table]![tblImagePath]![LoginD]

Good News! I came in early this morning and reformatted the DateTime field to NOT be a text field. I then went back to my query and entered ">DateAdd("h",-1,Now())". I ran the query and got exactly what I needed. Thank You!

the DB is too large... the field is Text (which is probably the issue) As I said earlier, I have taken the "datetime" field and split it to two fields for separate Date and Time. I could filter these columns. The format of these columns is: Time: format([dateTime],"ShortTime)

yes.. but let me try again I am getting records from a plethora of hour ranges (917PM, 2:41PM, 8:36AM, 9:30AM, etc. Not just the last two hours. (Nevermind the dates range is all over the place)

I think the "<" ">", "+", "-" combinations are throwing me. What I need to extract is records from today that we updated within the last hour.

When I use <DateAdd ("h",-1,Now()), I get 39 records dates ranging from today back to 1/10. The hours start at 4 AM to 4 PM

u OK... I put a ">" in front of DateAdd and got a bunch of records and then I put "<" and got less. So you were meaning "<>". Can I make the "DateAdd" statement a little more complex, like get current day and then filter the last hour?

In the DateTime column, I have "DateAdd("h",-2,Now())" and the query results in no records found (and there are at least three records that should show. I used -2 to make the selection timeframe a little larger. No records are displayed.

I have a query from which I want to pull only those records that have been updated in the last hour. In my file, I have a DateTime field (12/21/2016 9:18 AM). I would like the query to include this record and others if the time and date have changed within the last hour. I have read that using...

Nevermind. Giving variables is really difficult because they are calced elsewhere. They match if i round precision as 2, but stay same if i change precision to something else. I was thinking someone would look at the round statements and say i had a paren in the wrong place.

Again, the iif portions of this work exactly like i want them. I am asking for help on the Rounding and why it is not working.

I am asking about the rounding portion of the formula, not the "iif" statements. Those work fine. I am asking why the rounding does not work. It does not matter if i use 2,3,4 or 5 for the precision part, the result is the same

I have a formula that is not rounding correctly. Can someone figure out what I am missing? =IIf([FullCk]="-1",IIf([chkSDel]<>"-1",(Round(([TrkRate]+[TrkMU]+Nz([Rush$])+Nz([TotSurcharge])),4)),(Round(([trkRate]+Nz([Rush$])+Nz([TotSurcharge])),4)))) I have another textbox that is giving me a...

I added: "format(now,"yyyyddmm_hh-nn") & ".csv" the end of the output filename.

do you have an example of code to do that?

I went a completely different direction and used a series of DOS batch files that will accomplish exactly what I was attempting to do. I would still like to know what if it is possible to do this through the do.CMD procedure.

Is there an easy way to add a time and date stamp to my CSV file at the same time?