Search results
-
J
Recordset Filters from one user affecting all users on a form??
Good Day, Here is the environment: Currently, I have 10 Users running a front end form that connect to back end data where they add to current records and eventually check that the record is complete. I also have an "Apply Filter" button on the right hand side of the form that allows the... -
J
Failing to filter by criteria after return values from a function
OMG THANK YOU CJ London! SO HERE IS WHAT WORKED: SELECT [Main Table].[Unique ID], Nz([Main Table].[Start date]) AS [Starting Date], Nz([Main Table].[End Date]) AS [Ending Date], Business_Days_Between(([End Date]),([Start date])) AS [Days between] FROM [Main Table] WHERE (((([Main Table].[Start... -
J
Failing to filter by criteria after return values from a function
And this supplied code does display all I want untill i add that >7 condition, then it says data type mismatch error -
J
Failing to filter by criteria after return values from a function
Sorry for the confusion, Was trying to keep it simple in regards to field names and here i am murkying the water... Here is the full sql statement that isnt working: SELECT [Main Table].[Unique ID], [Main Table].[Start date], [Main Table].[End Date], (Business_Days_Between([End... -
J
Failing to filter by criteria after return values from a function
I did try to exclude the array and attempt to rerun the code in access and still getting the data type mismatch so I dont think its the dates in the array. And I am looking at my generated query without the criteria (>7) and my days between field is displaying accurate numbers... its just when... -
J
Failing to filter by criteria after return values from a function
First, I am too new to add links, apologies for the noob status. Second, you are right, i did have to change the dates, here is the first part of the code with the MODS i accidentally lied about: Dim lngTemp As Integer Dim datTemp As Date Dim x As Long Dim varHolidays(1 To 16) As Variant Dim... -
J
Failing to filter by criteria after return values from a function
Sorry: SELECT [Main Table].[Unique ID], [Main Table].[Start date], [Main Table].[End Date], (Business_Days_Between([End Date],[Start date])) AS [Days between] FROM [Main Table] WHERE ((([Main Table].[Start date]) Is Not Null) AND (([Main Table].[End Date]) Is Not Null)AND... -
J
Failing to filter by criteria after return values from a function
SOLVED: Failing to filter by criteria after return values from a function I will try very hard to elaborate on my issue! So I have a situation where I have two date fields in a table. I need to find the days between these dates and, if its greater than 7 days, I want to display the record in... -
J
"export" current record in form to another database
Good day, Currently, I have a database situation in which I am working in one database with data. If this data does not belong in this database I need to be able to take specific fields from the record and insert it into either a new table in a different database I have, or have it copied to... -
J
Lock a record the moment it is accessed
jdraw, Thanks for all the help. So i had a "Noob" fix to my problem, figured I would post it in case someone else was interested. My solution is easily fixable by going into the tools/options then the advanced tab and clicking the edited record radio button. My problem initially was that... -
J
Lock a record the moment it is accessed
The DB is not split, the greatest reason is there is some serious lag between linked tables within the provided network drive. I will read your link thanks! -
J
Lock a record the moment it is accessed
SOLVED:Lock a record the moment it is accessed Hello all! I am a first time poster, however I have followed this forum for quite some time and appreciate the level of help provided by those who are versed in the access world! Here is my situation: I am absolutely amazed that forums are not...