|
EXE from Access
I have Access 2003 and Visual Studio 2005.
A couple years ago I suppose I have done some tests that resulted in
the conversion of Access program into an executable program.
I can't find out what I have done and I am nor sure about all this
matter.
Can I have some help, please?
H. Martins...
|
25 |
11/21/2008 3:08:51 AM |
|
|
Combo box row height?
I have a cbo box that I use to choose addresses for customers that own
rental property.
Some of the addresses have two lines, like
111 somewhere
apt12
Is the a way I can get the cbo dropdown to show both lines?
...
|
3 |
11/21/2008 2:14:54 AM |
|
|
multiple users
Hi All,
I tried logging into the db with 2 users. The first user logged in and
everything was fine. While the first user is still using the db (.MDE), the
second user tried to log in. The second user keeps getting an error message:
"You do not have exclusive access to the database at this time. If you
proceed to make changes, you may not be able to save them later". That
message appe...
|
22 |
11/21/2008 1:25:00 AM |
|
|
display screen message
Hi All,
I would like to have a welcome screen appears after the user log in and then
close and open the main screen (switchboard). the welcome screen will be open
for about 2 to 3 seconds (more or less).
Any suggestions on how this can be done?
Thanks!
--
Learning ...
|
5 |
11/21/2008 1:07:01 AM |
|
|
Opening a form to a filtered record from a subform
Hi,
I have a subform that lists the names of samples that are related to the
sample on the main form. On the subform I have a hyperlink to one of two
forms which are supposed to open up filtered to the name on the subform.
Ie:
Main Form ----- sample 1
Subform-------sample 5... link to filter form 1 sample5
-------sample10... link to filter form 1 sampl...
|
1 |
11/20/2008 11:51:03 PM |
|
|
Can't close form after minor design changes
Have one form (out of about 20) that sometimes causes 100% CPU usage after a
seemingly small design change. Can't close the form or switch out of design
view. Get the message something like "Can't perform this operation at this
time" The only way to kill access (2000) is via the Task Manager which shows
100% CPU usage and only access running.
The change can be something as minor as t...
|
2 |
11/20/2008 11:37:46 PM |
|
|
Check previous record of another field null
Table: Time
Fields: Timein and Timeout are the ones i am concerned about.
Form (Actually subform) : timeentrysubform
on subform
command53 puts current time and date into the timein
command59 puts current time and date in the timeout
on the subform the employee times in and times out of the order throughout
the day with different work functions for job costing. All works beautifully
and i...
|
7 |
11/20/2008 11:27:04 PM |
|
|
Sending An Email And Performing An Action A Specified Period After A Control Has Been Updated
Hi,
I have a form where a user can select to take responsibility for a
ticket. At that point, the user will be able to view the record and
all other data pertaining to it, but no one else will. I want to set
a safeguard in the event the user forgets about the ticket or goes on
vacation, has an emergency, etc. and cannot complete the ticket or
manually put it back in the queue. I want to...
|
1 |
11/20/2008 9:53:40 PM |
|
|
Form query criteria doesn't recognize function
I have a listbox linked to a querie.
In some form, listboxA query criteria must respect some value stored
in listboxB.
Looks like queries can't read the content of a listboxB directly, so I
wrote a Static Function that reads listboxB and returns the value for
the query criteria of listboxA as Me.lstbxAlunos.Column(0)
It works OK.
====
Now I have a form without a RecordSource. The...
|
2 |
11/20/2008 9:30:17 PM |
|
|
Param Form Code ???
So I have a simple report that is fronted by a simple parameter form. On the
form they choose an agency from a drop down OR a region and then put in a
date range. I do not want them to be able to run the report by both a region
and an agency.
If they choose to run the report according to a region, I want them to be
able to choose region 1,2,3,4,5 OR ALL the regions.
I have a qry th...
|
3 |
11/20/2008 9:20:17 PM |
|
|
Absolute position in current subform
I have an Access97 form with a subform (subD1W) that displays a number of
values from a query. The query name is "qryD1W". The values are displayed as
a continuous form. When I change one of the values in the subform, I want to
determine the recordnumber (absoluteposition) of the value I just changed.
This will direct other functions.
I had it working in an Access2000 database, but w...
|
8 |
11/20/2008 9:18:02 PM |
|
|
checkbox notification
I have a subform on a mainform. The subform lists the tasks of the
mainform's project. There is also another subform on the mainform that is
for the requirements of each task. On the task subform there is a checkbox
that should only alert the user that there are requirements associated with
the task. This checkbox should be an automatic process based on the reqs
table. The 2 subforms...
|
2 |
11/20/2008 7:37:05 PM |
|
|
Repost-Please help-Search Lname and Fname
Hi -
I have a form open with temp table as record source contain fields Lastname
and Firstname.
- How I search lastname and Firstname in two (2) another tables have same
fields Lastname and firstname? If found list them all in 2 separate forms ?
Thanks you for reply!
...
|
1 |
11/20/2008 4:30:07 PM |
|
|
combobox allowing entry not in list
Hi
I have a combo box on form data2 with following in row source
SELECT [detail].[LotJob] FROM detail WHERE
StockCode=[Forms]![Data2]!StockCode;
This works but if type in combo box this is accepted even if not in list
as there are lots of lotjob against stockcode would like to be able to enter
lotjob but only accept if in list
Thank you
Tina...
|
3 |
11/20/2008 3:02:01 PM |
|
|
Close one form return to the previous one
I created a simple search on an existing form called FrmSales. The search
opens a search results form which was created from a query. I want the user
to be able to double click a job to select it and return to Form sales with
that job information displayed. It works, what I cannot get to work is
closing the search from. Below is the code:
Private Sub txtJobID_DblClick(Cancel As Integer)...
|
2 |
11/20/2008 2:31:17 PM |
|
|
Foreign language in Forms/reports
Hello,
I started to make tables as follows, but I want to know how can we make
query to pull the selected language:
tblLanguages
LanguageID
LanguageName
tblPhrases
PhraseID
PhraseName
tblPhrasesInLanguages
PhraseID
LanguageID
Phrase
Then you can write a simple query that can pull the correct phrase
based on the chosen language, and (for example) set the form tit...
|
2 |
11/20/2008 4:41:23 AM |
|
|
Automatic Fill for Certain Conditions....
Not even sure if this is possible, but here goes.
I have a form that allows users to input a "reason code" for each line of
data. Is there a way to:
Have the form automatically code items that have a percentage delivery
higher than 95%?
Have the form automatically code items that are blank in the field
"remaining" with the value that appeared in the "required" field?
Please help ...
|
10 |
11/20/2008 4:41:01 AM |
|
|
DoMenuItem Enquires
First tried: Delete with command below:
(Objectives: What I wana achieve is when checkbox is checked Aka ='True',
Particular recordset will be cut and paste into another table)
strsql = "INSERT INTO MyTable VALUES ('" &TextBox1 & "'"
CurrentDb.Execute strsql ' >>>
SQL Statement for inserting is fine
MySubform.SetFocus ...
|
3 |
11/20/2008 4:00:35 AM |
|
|
run time error 2113
I have a form where I have a combo box that is a lookup from a table
where there are only two fields 'location' and 'locationID'. It looks
up the 'location'. If the location isn't in the table the user has the
ability to add this to the table or list (a form will appear with two
text boxes 'location' and 'locationID' for the new values. It will
then ask if you want this value added to the lis...
|
2 |
11/20/2008 3:24:01 AM |
|
|
Help editing record set
I have some code to edit a record set. I cannot seem to get it working. Can
someone take a look and tell me why? I have set the form text box (txtDID) to
the second record in the table (6). When i go throught the loop, the msgbox
displays 5=6. Fine that is wrong so it should reloop. the next loop i recieve
6=6 in the msgbox but it does not do the edit. it jumps out of the IF? Can
someone...
|
9 |
11/20/2008 2:06:41 AM |
|
|
Designing a Form using VBA code ONLY
I want to create a simple form using VBA code ONLY.
I have a lot of experience with VBA code in MS Word and want to advance it to
Access. I have searched all over the internet and read books, but everything
just shows you how to do $*%# using queries, non-VBA macros, expressions,
control sources, row sources, record sources, blablabla, etc. I don't know
how you can keep track of a complic...
|
2 |
11/20/2008 12:32:57 AM |
|
|
object required
When this query tries to run it generates an "object required" error at the
Set strSQL. I'm unable to see any difference from others I've found in
searches. What am I missing?
Dim db As DAO.Database
Dim strSql As String
Dim varLO, varLL, varLS, varLTD, varTID As Variant
Set varLO = MyControl1
Set varLL = MyControl2
Set varLS = MyControl3
Set varLTD = ...
|
9 |
11/19/2008 11:40:06 PM |
|
|
check data before updating table
Hi
I have a form based on table which requires user to enter stock code and lot
number and quantity against bin location alreay in table . before data is
entered i would like to check that the lot number is valid against stock code
ie appears against stock code in another table stock code and lot number are
both strings .
I am struggling on where to start
Any help would be great
Thank...
|
15 |
11/20/2008 1:56:41 PM |
|
|
simple dlookup
Hi
I am trying to understand dlookup I am used to vlookup in excel but can't
seem to get it in access
I would like to lookup field both in form data and see if it is in table
detail in field also called both
both are text fields
Dim test As String
test = DLookup([both], "detail", [both] = Me.both)
If IsNull(test) Then
MsgBox -"your lot number is wrong"
I did get some help when try...
|
7 |
11/20/2008 10:54:47 PM |
|
|
store files (MDB)
Hi All,
From the original db.mdb, I will convert it to 2002-2003 format, then split
the database, then change it to .mde (I will be saving each step). I would
like to store the original db, convert format, and backend db in one secure
file. Then distribute the .mde to other employees. For the secure file, I
don't want other ppl to have access to it. should the .mde be able to obtain
...
|
5 |
11/19/2008 11:50:00 PM |