Tagged Questions
4
votes
0answers
163 views
Upload file with ADODB for Web-DAV “cannot find any objects or data in accordance with the name…”
I have an MS Access 2007 VBA application running on Windows 7. One crucial function is to upload files to a WebDAV server. The code below works perfectly on one PC, but fails on other PCs (and yes, ...
1
vote
0answers
25 views
Creative way to monitor an OCDB Access VBA app as a Service
I've got an Access VBA application that is responsible for querying a SQL table once per second over ODBC, looking for records where processed = 0. When it finds one, it will process an Access report ...
1
vote
0answers
77 views
getting the id number from another field
Im new to Access and need a little help
I have a form with a row view in the subform (all fields are not enabled), I want to make the line clickable e.g
Private Sub ID_Click()
recordID = Me.ID
...
1
vote
0answers
280 views
how to fix Run time error 62 ''Input past end of file'
I have a problem while trying to read a text file. Basically, the text file is comprised of blocks of information, between each block I have a blanck row. Hier is a sample of my text:
FESTWERT ...
1
vote
0answers
60 views
Difference Between ApplyFilter and SetFilter
What is the difference between the DoCmd.ApplyFilter and DoCmd.SetFilter methods? I looked them up on msdn and I don't see the difference. They even have the same arguements.
1
vote
0answers
63 views
Save routine creates two rows in table…one blank except for comment and the other is fine?
I have a userform that when a user clicks a button, it opens a new Comment log form. In this new form, I pull all the associated comments and display them in a subform/datasheet.
In this second ...
1
vote
0answers
74 views
Mass picture export
I inherited a database with about 5000 records in it. Each record as an embedded OLE with a picture. I want to move all of the pictures out of the database and replace them with a filepath. What would ...
1
vote
0answers
590 views
Adding a format condition in Excel through Access VBA
So currently i got these lines in my code,
.Range("C2").Formula = "=IF(B2 = """"," & """REQUIRED""" & "," & """""" & ") "
.Range("C3").Formula = "=IF(B3 = """"," & """REQUIRED""" ...
1
vote
0answers
173 views
Lock records when certain conditions are met
I'm creating a database that registers working hours.
People can introduce start working day, when and how long they take lunch break, and the end of the working day.
All works well, and I've created ...
0
votes
0answers
53 views
Display records one at a time using animation
I'm currently working on a project to display records in an animation whereby records will move up. I'm facing a problem allowing records to move up one at a time instead of all 8 records moving up at ...
0
votes
0answers
25 views
Parallel Proccessing for VBA website scrapper
I may be searching for this the wrong way. Here is the gist:
I am making a scraper. I get a list of URLs to hit that is usually about 200,000 URLs long. I want to scrape at a very slow rate (circa 3 ...
0
votes
0answers
22 views
Microsoft Access: Fix database columns with mixed mm/dd/yyyy and dd/mm/yyyy entries
I have run into an unusual situation where ActiveX controls have been auto-formatting dates to the mm/dd/yyyy format when the rest of the database is using dd/mm/yyyy. Depending on whether the user ...
0
votes
0answers
49 views
check if attachment field is empty vba access
I have a form with a combo box for a user to select from a range of dates. The form is based of a table where each date is a record. Each date has up to 6 attachments, each in a separate field. How ...
0
votes
0answers
14 views
Updating a subform from a list on form
I have a list control on my form. The values of this list come from a query. the Row source of the List is like this:
SELECT tb_lable_Daten.name
FROM tb_lable_Daten;
and Control Source of the list ...
0
votes
0answers
22 views
Save Button not adding all fields correctly
This is my code for saving a record :
DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70
SendKeys "+{ENTER}", True
DoCmd.GoToRecord , , acNext
My problem is when I save the ...
