Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 500
Search took 0.05 seconds.
Search: Posts Made By: static
Forum: Queries 10-06-2017, 06:55 AM
Replies: 5
Views: 203
Posted By static
Re: cross-table query not shown correctly in table from make-table query

A query can't be 2 things at once.
It can either be a crosstab or a maketable.

You can use one query inside of another (different type of) query though.

select * into newtable from...
Forum: Modules & VBA 10-06-2017, 06:37 AM
Replies: 4
Views: 208
Posted By static
Re: Export Query to Tab Delimited Text File VBA Code

Leave 'Export data with formatting' unticked.
Forum: Queries 10-06-2017, 05:57 AM
Replies: 4
Views: 202
Posted By static
Re: Slow query - can I make it run faster?

If both tables should be the same, delete and insert everything from scratch.


If you UNION both tables together you can check if they match by GROUPing...

select [Kreditor nummer], Sum(n) AS...
Forum: Forms 10-05-2017, 02:35 PM
Replies: 8
Views: 289
Posted By static
Re: #Error - Form Field

text105 references check62 which doesn't exist
Text99 references FieldName which doesn't exist

Your naming of controls is atrocious.
Forum: Forms 10-05-2017, 01:22 AM
Replies: 23
Views: 501
Posted By static
Re: Form on mouse move event?

You don't need to paste in the click events. Generate them when the form opens.

Private Sub Form_Open(Cancel As Integer)
For Each c In Controls
If Left(c.Name, 5) = "btnID" Then
...
Forum: Forms 10-03-2017, 08:55 AM
Replies: 9
Views: 235
Posted By static
Re: Mismatch Error 13 with dates

Pass the date to your function along with the ID

Public Function MonthlyAmt(FLNo As Integer, dt as date) As Currency

MonthlyAmt = DSum("matchamount", "tbmatchamount", " EmployeeID=" & FLNo & "...
Forum: Modules & VBA 09-29-2017, 09:36 AM
Replies: 4
Views: 237
Posted By static
Re: Error handling

The structure of your code helps too. If you split your code up into separate functions that return true if they pass or false if they fail your 'main' procedure is easy to read.

So instead of
...
Forum: Forms 09-29-2017, 09:08 AM
Replies: 60
Views: 1,444
Posted By static
Re: Emulated split form problem

See. Even Microsoft can't get it to work. :p

edit:

added record highlighting and fixed error 2105

68000
Forum: Forms 09-29-2017, 08:26 AM
Replies: 60
Views: 1,444
Posted By static
Re: Emulated split form problem

:)

1) Home Ascending / Descending. It's there whatever type of form you are using. No?
2) I have no idea! It's only using the table and controls should make no difference.

I like picky. It...
Forum: Forms 09-29-2017, 07:22 AM
Replies: 60
Views: 1,444
Posted By static
Re: Emulated split form problem

1) By clicking sort in the menu.
2) This uses one form, one recordset. 67959
Forum: Forms 09-29-2017, 06:48 AM
Replies: 60
Views: 1,444
Posted By static
Re: Emulated split form problem

And I think while ever you are trying to work with 2 instances of the same recordset you will always have these problems.

If you build the continuous form and then put the single form controls in...
Forum: Forms 09-29-2017, 06:20 AM
Replies: 60
Views: 1,444
Posted By static
Re: Emulated split form problem

I had a few issues. (2010)

- If I click continuously (quickly) on the next record I get error 2105 : you can't go to the specified record. (same on back)
- If I edit a record in the single view...
Forum: Forms 09-27-2017, 12:38 PM
Replies: 60
Views: 1,444
Posted By static
Re: Emulated split form problem

I can't get it to work now either. :rolleyes:
I must've cocked something up somewhere.
At least you have something you're happy with. :p
Forum: Forms 09-27-2017, 02:03 AM
Replies: 60
Views: 1,444
Posted By static
Re: Emulated split form problem

Works fine here.
make sure set f = is after the other bits of code.

All code is in frmSplitter.
It's bad enough having three forms. If you wanted more split forms you wouldn't want to create a...
Forum: Forms 09-27-2017, 01:36 AM
Replies: 60
Views: 1,444
Posted By static
Re: Emulated split form problem

So I guess sorting recreates the recordset and essentially orphans the 'clone'.
Trap the error and reassign the new rs.

Dim WithEvents f As Form

Private Sub Form_Load()
...
Forum: Forms 09-27-2017, 12:51 AM
Replies: 5
Views: 208
Posted By static
Re: COmbobox value in one form populates in a cbo in another form

docmd.openform "form2"
forms.form2!NameofYourCombo = NameofComboOnForm1
forms.form2.Recordset.FindFirst "[Category_ID]=" & NameofComboOnForm1
docmd.Close acform ,me.name

edited based on other...
Forum: Modules & VBA 09-26-2017, 02:07 PM
Replies: 8
Views: 243
Posted By static
Re: FTP dial up and xml file download

That's a lot of code. Did you try httprequest?
Forum: Forms 09-26-2017, 01:43 PM
Replies: 5
Views: 208
Posted By static
Re: COmbobox value in one form populates in a cbo in another form

In design view, select the button
On the property sheet select [event procedure] + click the ellipsis.
In the procedure paste.

docmd.openform "form2"
forms.form2!NameofYourCombo =...
Forum: Forms 09-26-2017, 01:14 PM
Replies: 3
Views: 178
Posted By static
Re: Form control default values from 'many-to-many' form

Hey.

I don't really get 'coffeeprice'.
Where is the 'coffee' table? How does price relate to types of coffee?
At the risk of sounding flippant, wouldn't it always be 'free'?

I'd just have...
Forum: Forms 09-26-2017, 10:53 AM
Replies: 60
Views: 1,444
Posted By static
Re: Emulated split form problem

Good spot. That's because nav buttons on the sub are turned off, but I didn't turn them on the container form ;) Should be the other way around.

I got an error when sorting the continuous form....
Forum: Forms 09-26-2017, 09:45 AM
Replies: 60
Views: 1,444
Posted By static
Re: Emulated split form problem

If you use a dedicated form as the splitter updates seem to work for both forms and you can add a resizer.

67891
Forum: General 09-20-2017, 02:58 PM
Replies: 9
Views: 502
Posted By static
Re: Loop Error

I had to google refreshrecord.

'In a client database, the RefreshRecord method is equivalent to the Refresh method of the Form object. In a web database, see the RefreshRecord macro action.'
...
Forum: Forms 09-20-2017, 11:53 AM
Replies: 25
Views: 1,373
Posted By static
Re: How to display 10 Images horizontally on a continuous form using vba

@Exi: It was an image of your form based on my form that you uploaded in a zip.

@linux: Links to the original files are in post #5, page one of this thread.
Forum: General 09-20-2017, 11:47 AM
Replies: 8
Views: 626
Posted By static
Re: Question regarding Access performance

I guess it isn't saying those other programs are better, it's just saying if you aren't on Windows or want something free, alternatives are available.

After asking 'Why are MS Access alternatives...
Forum: Modules & VBA 09-20-2017, 11:29 AM
Replies: 17
Views: 394
Posted By static
Re: string function ( right function )

You added the new field.
You just need to change the controlsource for the Total textbox in the subform to the new field.

67794

The data in your table didn't match the format you said it...
Showing results 1 to 25 of 500

 
Forum Jump



All times are GMT -8. The time now is 06:36 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Sponsored Links

How to advertise

Media Kit


Powered by vBulletin®
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World