jonnycakes
Last Activity: Aug 2 '13, 07:45 AM
Joined: Jan 28 '12
Location:
-
Could you not just create a query in access and use docmd.transfers preadsheet, dao, or ado connection? -
Turns out that there's a known "bug" with SMB 1.0. My issue would be corrected if I had SMB 2.0. More information can be found here: http://blogs.technet.com/b/filecab/a...26/458221.aspx
And here:
http://social.technet.microsoft.com/...-40f3358472c5/
Hope this helps somebody out there....Leave a comment:
-
available free space of shared network folder with quota
Hello Bytes,
My Goal: In Access with VBA, I need to return the amount of available freespace of a shared network folder that has a quota.
In case that it matters, I want to point out that i'm working out of MS Access 2000.
Example: X:\SharedDrive1 \Folder1\ In this case I would want to know the available space that Folder1 has.
It's important to know that SharedDrive1 and/or Folder1 may change (quotas... -
NeoPa, I cannot thank you enough for the education that you've provided me, thank you! I have noted everything that you have shared with me. I've also learned a valuable lesson, and that is, never type out your code on your iPhone :)
The only thing that I can add to your great solution is that, lines 3 and 5 require an extra right parentheses to close the replace function.
NeoPa, you're doing a great service to this community,...Leave a comment:
-
Yet again, NeoPa comes to the rescue. Please accept my apology for my delayed response. I hurt my back shortly after I posted this question. I went with option one, because this dataset will continue to grow. At least I think I went with option one, I've included the code that appears to be working. Do you see any issues with this approach, or did I use your suggestion correctly?
Thanks again!!
...Code:Dim StartDate as Date
Leave a comment:
-
Me.Filter Date/Time field, exclude time
Hello everyone,
Long story short, I have a button that i'm using on a form to allow the end user to filter by selection. This is working great for me, all except with my Date/Time fields.
My goal is to ignore the time in these fields and return every record that was entered that day, but I seem to be missing a key element.
For simplicity, both my field and my control are named "RecordSTS" .... -
Yes, thank you for this! Very easy to understand even as a novice. Can this process do any harm to the database? I understand that I should make a backup, but what are the risks involved?
I'm considering using this method, but I'm not sure what I should be testing to ensure nothing went wrong.
Thanks again.Leave a comment:
-
Smiley, Thank you for your detailed response, but the second test(opening the local table while another local table was opened) did not do the trick. I'd like to also update my previous estimate of a 2 minute lag, it actually takes 4 minutes to to open this table.
I haven't tried the "stayconnec ted" method that you shared, but I am very interested. Currently, I'm using the code found here: http://www.fmsinc.com/Microsoft...Leave a comment:
-
Local tables opening slow Access 2000
Hello again to my favorite forum,
So, I have an Access 2000 split database, the backend (mdb) is stored on a shared drive while my front end(mde) is stored on my local machine. I'm experiencing a long wait time when attempting to open local tables and linked tables.
I found this article in many places during my search for a solution: http://bytes.com/topic/access/answers/728919-slow-opening-local-tables-access-2003-... -
Two ways of doing this to my knowledge, but there's probably other options..
IMHO The best way is to use the after update event of the combobox. If possible your combobox query should include all of the values you want populated in your textboxes. Then your combobox after update will read something like this:
Where the N references the column number in your query that...Code:Textbox1.value = Me!ComboboxName.columns(N)
Leave a comment:
-
Well the % may change, but it's very helpful for me to know that the top function will round up. Given that this function acts with such behavior, my assumption is that the result of this query will yield a much larger % of management's records.
My goal was to have each manager to review n%(25, 60, etc) of records. It's important that each manager reviews at least 1 from every employee. Equally as important these records should include...Leave a comment:
-
Bullet 1: Your comment makes sense.
Bullet 3: Yep, I failed to explain my thoughts completely.. it didn't make sense for me to filter out the zeros. I originally thought it would be better to filter out the zeros and build a query to capture only records that contained zeros in that column, and then use a union all to tie them togther.
If i'm not mistaken, I believe my code has been corrected to comply with points 1 &...Leave a comment:
-
As you can see i've struggled with this immensely.. I am terribly sorry for taking up your time with this haggered code. I hope that after I review this and respond back, that you have it in you to provide further assistance.
Thank you!
btw, you are an absolute beast(same goes for NeoPa) and I can only hope to gain half of the knoweldge that you have....Leave a comment:
-
Query to pull top n% of records that include specific criteria
I've been trying to do this for a long time, and i'm at the point where my head may explode.. Please take caution when reviewing my code as it may cause more confusion than it is intended to.
I've got a table named Test that includes multiple fields:
[Management]|[Group]|[Employee]|[Amount]|[Variance]|[DateTime]
I'm trying to pull 25% of the records for each of the Managers listed in the "Management "... -
jonnycakes replied to Update Query/Sql; populate data that depends on date field between variable rangein AccessI love you. Thanks again.Leave a comment:
-
jonnycakes replied to Update Query/Sql; populate data that depends on date field between variable rangein AccessOutstanding, i've made great progress, thank you! I'm not sure why, but when using the between operator in my access query I recieved an error message mentioning something like "expression missing and operator".
I got around this by replacing the "between" and "AND" with >= & <=, but this doesn't seem to work completely as I'm left with thousands of records that weren't updated. I believe this...Leave a comment:
-
jonnycakes replied to Update Query/Sql; populate data that depends on date field between variable rangein AccessRabbit, thank you for your reply! The good news is that as it turns out I do have a start date :). Of course I'm not expecting you to just tell me the answer, but could you expand on how I would go about the between statement?
This is the BEST forum out there IMHO.Leave a comment:
-
jonnycakes started a topic Update Query/Sql; populate data that depends on date field between variable rangein AccessUpdate Query/Sql; populate data that depends on date field between variable range
I had a terrible time coming up with a title for this question and an even worse time trying to solve my issue. I'm here seeking guidance yet again from the masters.
Let me outline the two data tables i'm working with and then i'll present you with my issue.
Data Table 1: "tblOffer"
tblOffer consists of close to 1 million records. In each of these records you will find an employee name, employee ID,... -
I feel very stupid right now.. I don't know why i didn't think of this sooner, but I decided on splitting up my report into two seperatatle reports. One report will be a shared workbook that merely provides the raw data as well as provide the end user with the option to flag each record with a simple list box. .
The second report will not be shared, but rather a read only report. This report will contain all of the data analysis, and...Leave a comment:
-
They need a report with the option to flag each record as reviewed. Currently, they have a drop-box with "Y" or "N" (excel) as options to signify whether the record has been reviewed.
I have several problems with this. Problem 1: Shared workbooks do not allow me to easily update the raw data on a weekly basis or run macros. Problem 2: When distrubting individual files via email I have no way of knowing what was...Leave a comment:
No activity results to display
Leave a comment: