I am trying to load a text file in sql with a schema file using
opendatasource('Microsoft.Jet.OLEDB.4.0','Data Source=C:\
The file has
Total length 1621
Number of columns 312
If i c...
This is a model that I built that I would like to implement into production. The horizontal bar between the mocked up subforms moves up and down resizing the subforms. When I use this same met...
Dim pwd As String
Dim pwdDate As String
pwdDate = Format(DateSerial(Year(Now()), Month(Now())), "YYMMDD")
pwd = UserGroupID & pwdDate
"""\\ServerName\PACOMP\PACOMP.exe"" -a...
Hi,
I am using Access 2007 to run a database that manages serial numbers. One of the values that we require in our reports is an aggregate sum based on a decimal valued field. The problem is...
Here is the error I'm getting in Access 2000:
Syntax error (missing operator) in query expression 'agents.am_label2 = calls.am_label1
INNER JOIN (SELECT * from Table1 WHERE metric_name='tic...
I have used this code before and it has worked fine, however, now I am getting an error "Method or data member not found". I have a reference to the MS Office 12.0 Object Library. I have als...
I have a client with a complicated Access database structure. they have a procedure that appends data into an invoicing table. The data comes from a couple of different databases and is appe...
I'm trying to create a series of forms.
Search>result>Record update.
I get to the record update, fill in details, click on 'update' and get the following message returned
any ideas where it...
To simplifie the data entry, I want to combine 2 fields.
I dont have problem to create the list of the combo box and assign the value in the table.
But I cant show the current value from...
Hi, I have a report that is being generated from a form. Behind the form I am using vba code to gather information and populate it to a report. In the code I use the code below. However the...
Hi there, i created a form to into data into a table. I have loaded the dropdownlist with some dynamic values from another table. Now when i click my drop down list, i can only see 1 field fro...
Hi Experts
I have Adobe pro 7 and Adobe reader 8.x.
How can i test if i open a PDF file that it uses Adobe Pro 7? It is because, if I print some PDF files from vba with ShellExecute, i ...
Hi Guys,
Hoping you can help me out. I have a form to enter a new record in a table. The primary key of the table is a long integer autonumber field. I set the form to DataEntry "yes" to it ...
On my machine with access 2003, controltip takes about 5 seconds to display, which is annoying.
So, I am looking for a simple way to speed things up. A tools option (or even a registry ha...
I need to change the name of a table that is used in several hundred queries from tbl_OLD to tbl_NEW. When I do this manually (i.e. simply by right-clicking and renaming the table) the change...
How can I set up referential integrity relationships between three tables: Game, Team, and GamePlayer, where
- Game has fields: Game#, HomeTeam, AwayTeam
- Team has Fields: TeamName, PlayerN...
I have a checkbox on a form which get its value from a query (rowsource) in a combo box. If the value of this checkbox is true based on the selected record in the combo box, then I want the v...
Hello ~ I want to display 'FamilyID's from 'tblIntakes' that do not appear in 'tblTeamMeetings' when tables are joined on 'FamilyID'. The following statement shows no records.
...?
There is a excel file in a shared drive: O:\test.xls (edited by other users)
I linked the excel sheet as table (just right click on Tables tab area, select link and chose the test.xls) so t...
HI
I need to replace part of the string in a field, the data is something like this:
\\Server\LogicalBusinessSolution2008\imagenes\pic1.jpg
\\Server\LogicalBusinessSolution2008\imagenes\p...
I am going to have to upgrade an Access 2003 database to 2007. The main menu currently hides everything in order to maximise the viewable info and then the main screen has a command bar of ic...
I have a form that I would like to display the results based on Start date and End date using an unbound text box for start date and one for end date. I know I can do it from a query but I wan...
This is kind of crude code, but what I am doing should be a no brainer. It is a no brainer in vb 6.0, but I can't do this in VBA for Access? The math is simple .ListCount - 1, but it doesn't ...
Installed Microsoft Access 2000 from CD on a computer running Windows XP Home (sp2).
I do not have MS Office suite. Only the Access 2000 program on a Microsoft disc.
Went to install updates...
I'm trying to fill in a login to a webpage in order to allow users to access certain data. What is the name of the text box labeled "Username:"? I get an error message - mentioned in the code ...
