So I had a report that called with its Record Source set to TableA.
I then made a copy of this report, but change the Record Source to TableB.
TableB is a summary of TableA, and is missing one field, NAME
So when I run my report, it pops up asking for the paramater for NAME.  I
looked at the report and deleted the feild that was linked to NAME.  The
report is still asking for NAME, even though no feilds on the report ask for
it now.  How do I go about fixing this?


Read whole thread:
Report Asking For a Parameter

If you have a command button, I'll assume you are working in a form.

If so, what about adding a control on the form that displays the "last date
run"?

Regards

Jeff Boyce
Microsoft Office/Access MVP

"RobertG" <RobertG@discussions.microsoft.com> wrote in message
news:92EA01EE-70E7-47CD-91F9-C65100A57850@microsoft.com...
> Hi all,
>
> I have a report that is run from the OnClick event of a command button.
> When this occurs, a query is ran that updates the UserID and ReportDate in
> tblReportHistory with their respective values.
>
> What I would like to do is display a msgbox if the last time the report
> was
> run was before the 16th of the current month.
>
> I know I need to check for the current date, date the last time the report
> was run, and compare the two.  I'm thinking I need to use the DateSerial
> function to achieve my goal, but I have no idea how to do so.
>
> Any help/suggestions?
>
> Feel free to ask for additional info, if needed!
>
> Robert


Read whole thread:
Check when report was run last

Chris

I can't tell from your description, but it sounds like you're talking about
the design view, not the table (or query) itself.

After all, if a query only has three columns, running the query only
generates three columns...

Or am I missing something?

Regards

Jeff Boyce
Microsoft Office/Access MVP


"mcescher" <chris.meinders@gmail.com> wrote in message
news:6618e12b-c6fe-49b1-b020-f6cb9765d810@s12g2000prg.googlegroups.com...
> Hi All,
>
> So, when I'm working in Access, and create a new table or query,
> Access assumes that the window should set up for like 20 columns and 8
> rows of data (short and fat).  But sometimes a table I create only has
> two or three columns, but a lot of rows.  Saving the table tall and
> skinny doesn't save the table like that.  The next time I open it,
> it's formatted short and fat again.
>
> Is there a way to save the asthetics of the table?
>
> Access 2002 SP3, Windows XP Pro
>
> Thanks for your time,
> Chris M.


Read whole thread:
Saving the asthetics

Supe,
It always helps the volunteers who answer questions here if you include as
much information as possible about the problems.
What file type are you importing from?
Try importing the UPCs into a table with field type text.
If successful, use a query to format the data as you need and import it into
the real field in your acess table.

Jeanette Cunningham


"Supe" <Supe@discussions.microsoft.com> wrote in message
news:926923E7-EDE1-431D-99E4-9995BD0D3BB2@microsoft.com...
>I am trying to import some 10 digits UPCs into a table but it only imports
> the UPCs that start with 1.  Any UPC that starts with anything other than
> 1
> is left blank in the table.  The descriptions all import, but not the UPCs
> that start with anything other than 1???????


Read whole thread:
Import Error

"Bob Barnes" <BobBarnes@discussions.microsoft.com> wrote in message
news:321B240C-9F71-4EA9-877E-771D14689109@microsoft.com...
>I can print a SNP File from a Report and attach to an Email, like this..
>
> DoCmd.OutputTo acReport, "LatestRecs", _
> acFormatSNP, "C:\BobDev\ASNP.snp", False, ""
>
> I know a Printed Report can be better formatting than a Printed Form.
> However, I'd leke to have a "Print screen" of a Form, and make that a
> SNP file.  How can I do that similar to the DoCmd.OutputTo...above?

As far as I know, it's not possible.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)



Read whole thread:
Snapshot of a Report

Do you have (or did in the past) multiple versions of Access installed on
this PC?

If so which versions and where are they installed - file paths?

--
Jeff Conrad - Access Junkie - MVP Alumni
SDET - XAS Services - Microsoft Corporation

Co-author - Microsoft Office Access 2007 Inside Out
Presenter - Microsoft Access 2007 Essentials
http://www.accessmvp.com/JConrad/accessjunkie.html
Access 2007 Info: http://www.AccessJunkie.com

----------
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.mspx
----------

"vandana" wrote in message:
news:7449F183-0D06-46F4-8A30-F451BD895056@microsoft.com...

> Tom,
>
> I am trying to import excel data in access 2007 and in importing
> spreadsheet
> wizard I am getting same error - "error in loading dll". I tried to
> register
> both file on http://support.microsoft.com/?id=833220. but it says "This
> article applies only to a Microsoft Access database (.mdb). " while my
> database is .accdb and also there is no dll file installed on my computer.
> what should I do? please help.


Read whole thread:
Access 2007 Error in Loading DLL

On my website (www.rogersaccesslibrary.com), is a small Access database
sample called "CascadingComboBoxes.mdb" which illustrates how to do this.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L


"deb" <deb@discussions.microsoft.com> wrote in message
news:7AC95421-EF7B-4A24-96CA-9AD6CB669FC1@microsoft.com...
> Please help, with a cascade combobox in a sub form.
>
> I would like make a selection from the combobox named cboSiteID in my main
> form named f4Project and have the combobox named cboUnitID in my sub form
> named t032ProjUnit be limited to only the records relating to the SiteID.
>
> How can this be done?
>
> Thanks in advance!!
>
>
> --
> deb


Read whole thread:
cascade combobox in a subform

*ordre de détruire microsft public acces*












microsoft.public.access va sotodétruire quand ce message sera jeté

Read whole thread:

Here's an example of how to do it:

http://www.datastrat.com/Download/MouseMove.zip
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

"PeteCresswell" <PeteCress@gmail.com> wrote in message
news:acaea3da-7c88-41d7-91c8-d873989de95d@b1g2000hsg.googlegroups.com...
> I've got a form that goes in and out of "Edit" mode.
>
> There's also a subform that's never editable, but has an underlined
> field that I want to treat as a hyperlink.   i.e. when the user clicks
> on that field, I drill down and show some supporting info.
>
> The only event I see so far is "MouseMove" - in which I could set
> Application.Screen.MousePointer to whatever value I deemed
> appropriate.
>
> The hitch seems tb that once set, it persists when the pointer is
> moved to other places on the screen - seemingly needing MouseMove code
> behind every object on the screen to make the cursor act appropriately
> for each object.
>
> Is there any way I can change the pointer just when it is over a
> certain field without coding a MouseMove event for every object on the
> screen?   This is my main concern.   It seems confusing from a UI
> perspective for the user tb  having to click on something when the
> pointer is an insertion bar instead of an arrow.
>
> Secondarily, is there a way for me to keep the MousePointer an arrow
> when it's over a text field, but the screen is in "Browse" mode?   I
> don't want to set .Enabled=False bco the effect on other field props.


Read whole thread:
"Hover" event?

"Matt" <Matt@discussions.microsoft.com> wrote in message
news:47FFADE3-F2F2-46A7-B9BC-411BA48DE685@microsoft.com...
>I recently created MDE files to distribute, but cannot enter data into any
>of
> the existing fields when I open it.  Is this just the way it is or did I
> miss
> something?

The only difference between an MDB and an MDE is the code is compiled so
that you cannot view or create forms, reports, or modules. You must have
another problem.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com


Read whole thread:
MDE read only