gettting the aforementioned error 438....
when this code runs
Private Sub cmdLoadOLE_Click()
Dim MyFolder As String
Dim MyExt As String
Dim MyPath As String
Dim MyFile As String
Dim strCriteria As String
MyFolder = Me!SearchFolder...
I have a select query script that runs fine. I am trying to create a mview with it but when I try to create the view,it runs and runs and never creates the view; I have to cancel. I let it run for an hour without success, the actual select query takes about 5 seconds.
create materialized view...
I have installed new motherboard and cpu.
New cpu is intel celeron D 2.4ghz processor m/board is foxconn 865a01-pe-6ls
RAM is 512 mb ddr pc2100
I hit the power on button and the cpu fan starts up but nothing else happens no beep
so post isn't happening.
Any help much appreciated.
I have a dropdown list in a cell on a spreadsheet where the user selects a name and then all jobs associated with that person are displayed. I want to display only the jobs currently being worked on/ not completed.
Completely new to excel although have done some access programming. I imagine an...
Hi, I have an email sub procedure that sends an order as an attachment. However if the company does not exist in outlooks contacts then outlook opens and asks the user to select the recipient. I want to be able to test to see if the order was
sent or cancelled and output an appropriate message...
I have just upgraded my pc to xp pro from win 2k and can no longer access my other drives (win 2k).
other drive(e:) shows in bios and in my computer but cannot open.
c: drive is raid array 0 using 2 drives and hot rod 100 pro card, e: drive is also connected via raid card rather than m/board...
Hi I have a win 2k server + home network; one of the local machines running win2k pro is used a lot as a standalone pc but is also able to connect to the domain. However after it has been used as standalone for a while it will not reconnect to domain, gets as far as applying computer settings...
I have columns of text boxes in a report, They are set to 'can grow' which they do, but they grow behind the text box below??
or some actually show the text but superimposed over the text in the textbox below??
any help with this much appreciated
I need to remove rows that hold no data from a report.
I thought if I used zero height for the controls on the report and set can grow to yes that the controls would only be visible and take up space if they held data but....
This is what the report looks like now with 0 height and can grow...
Hi I want to be able to hide controls on a report depending on
the value of a global variable.
like...
if mode = "dc" then
prodname.visible=false
....
....
end if
is this possible?
would I use me.prodname?
B
I have tried mapping a drive to a folder on the server from a pc that is on the network, but not in the domain. The user logs on to the local machine not the domain.
I set it to reconnect at logon and to logon as another user.
The other user being a user in the domain with rights to the folder...
Hi, I have a small test network with one server running win 2k server. The server is a domain controller, the server cannot access the internet via the router ( dynalink RTA300 ). Yet users on the local machines can when logged on locally or on the domain.
I have limited networking experience...
Hi I have a small home network with a HP Netserver LC3 I want to create a domain and setup active directory, more just to explore and learn than for any practical purpose.
The server and network pc's come off a switch which also has a adsl router connected to it.
Do I have to have a real domain...
I have field in a table that is date/time shortdate
my regional settings for date (short) are dd/mm/yyyy
when I perform an insert on this field the date gets inserted as mm/dd/yyy
could someone tell me how to correct this.
the date field is used in parameter query the user enters start/end...
have a query that runs and need to check to see if it returns a value
strSQL = "select ..........."
if not isnull (strSQL) then
...........
else
..........
end if
will this work
Hi, I have a server (HP netserver LC3) that was switched off during a reboot sequence and since then there has been no input signal to the monitor. When switched on the fan starts :) and lights come on, on the cd drive and the main scsi drive. they then go out and the monitor never comes out of...
I,m having trouble with a report that is based on a query. In the query the criteria for each field is a function that returns a value(this value changes) from a global variable.
when I run this code...
DoCmd.OutputTo acOutputReport, report_name, acFormatRTF, "C:\Documents and Settings\Bob\My...
using variables in reports, runtime error: 2147352567
I get the above error when I try to preview a report, also says "cant assign value to object".
I have a report with controls that I want to assign values to using variables.
the variables are global so...
txtcontrol = variable in open...
When i click in a field in the properties window I cant insert cursor without all text to the right being selected.
clicking on the 'u' of the control name "txtuser_id" will result in all the text 'user_id' being highlighted.
I want to be able to click on the 'u' and be able to use backspace or...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.