Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 212
Search took 0.05 seconds.
Search: Posts Made By: smile
Forum: General 01-22-2015, 11:00 AM
Replies: 1
Views: 569
Posted By smile
Re: access currency symbol change

Just found this
http://allenbrowne.com/ser-44.html

Is there macro or something to reset this database wide?
Forum: General 01-22-2015, 09:22 AM
Replies: 1
Views: 569
Posted By smile
access currency symbol change

Hello, after local currency change to Euro, I changed the currency symbol in the regional settings on my PC, however now access shows the nonsense like :

#.##0,00" Lt";-#.##0,00" Lt"

Instead of...
Forum: Queries 01-26-2012, 02:22 PM
Replies: 13
Views: 3,466
Posted By smile
Re: query filter error

I found a code that allows me to populates text box on my form with comma separated values from the listbox



But for some reason when I pass the criteria on my query using the text box it only...
Forum: Queries 01-26-2012, 09:28 AM
Replies: 13
Views: 3,466
Posted By smile
Re: query filter error

But this is the same issue I'm having. I need to filter a query that makes data for my report by using listbox extended (multiselect), and you posted about custom code I need.

I read the articles,...
Forum: Queries 01-26-2012, 07:23 AM
Replies: 13
Views: 3,466
Posted By smile
Re: query filter error

Hello, I have multiple queries filter by date as criteria and then I open a report from those queries by using a button on my form.

Button code is like this:



I have inserted a listbox to my...
Forum: Queries 01-09-2012, 10:33 AM
Replies: 13
Views: 3,466
Posted By smile
Re: query filter error

I don't know what to search for, can you give me any keywords?
Forum: Queries 01-07-2012, 03:18 PM
Replies: 13
Views: 3,466
Posted By smile
Re: query filter error

I have no idea how to write VBA, most of stuff I know I have learned from this forum by example.

I can provide a database sample if you could take a look at it.
Sorry if my English is bad.
Forum: Queries 01-05-2012, 03:26 PM
Replies: 13
Views: 3,466
Posted By smile
Re: query filter error

Thank you, I'm so grateful. You saved my day :)
I see this works for text box and comb box too.

If I would like to use a list box (I think it passes as many variables as I select right?) to...
Forum: Queries 01-04-2012, 04:42 PM
Replies: 13
Views: 3,466
Posted By smile
query filter error

Hi, I have a query in my database that filter data from 2 tables with relationship
one to many between tables. I also have a form with text boxes for inputing data to the query.

In the query I...
Forum: Windows 09-29-2009, 11:43 AM
Replies: 0
Views: 1,753
Posted By smile
Fix GIMP plugin path problem in python script

I have downloaded the batch_restore.py from
http://www.lionhouse.plus.com/photosoftware/gimp_plugins/

I'm using Windows XP SP3 With GIMP 2.6

I don't know any python, but I understand...
Forum: Forms 01-17-2009, 06:58 AM
Replies: 9
Views: 14,273
Posted By smile
Forum: Forms 01-11-2009, 09:14 AM
Replies: 9
Views: 14,273
Posted By smile
Re: How to delete selected record on subform with delete button?

Hmm, I now see that becaue this code

Dim rs As Recordset
Set rs = CurrentDb.OpenRecordSet("Select * from [tbl_type]")
rs.FindFirst "[ID] =" & Me!List3
rs.Delete
Me.List3.Requery

works...
Forum: Forms 01-10-2009, 04:49 PM
Replies: 9
Views: 14,273
Posted By smile
Re: How to delete selected record on subform with delete button?

See my attached image


So how do make it work? Is my solution on post 5 correct?
Forum: Forms 01-10-2009, 03:39 PM
Replies: 9
Views: 14,273
Posted By smile
Re: How to delete selected record on subform with delete button?

I know about correct naming, sorry was in a hurry just made a sample db using the wizard ant it named my form as tbl because it was created from table.

Just trying to understand the correct way to...
Forum: Forms 01-10-2009, 03:16 PM
Replies: 5
Views: 981
Posted By smile
Re: Delete a row from a listbox

I have tried this code and it seems to work:

Dim rs As Recordset
Set rs = CurrentDb.OpenRecordSet("Select * from [tblEmployees]")
rs.FindFirst "[EmployeesID] =" & Me!List0
rs.Delete...
Forum: Forms 01-10-2009, 02:28 PM
Replies: 5
Views: 981
Posted By smile
Re: Delete a row from a listbox

I have same problem posted here:

http://www.access-programmers.co.uk/forums/showthread.php?t=163572

Have tried your solution and got this error:

Syntax error (missing operator) in query...
Forum: Forms 01-10-2009, 08:31 AM
Replies: 9
Views: 14,273
Posted By smile
How to delete selected record on subform with delete button?

Please see attached db example.

View forms tbl_type and tbl_type1

First is made with listbox second with subform.

My problem is that I can't find out how to:

How to delete selected...
Forum: Reports 12-03-2008, 10:11 PM
Replies: 14
Views: 1,795
Posted By smile
Re: optimized way to make a report?

I would partially agree with you, but as I said I'm no access expert and don't pretend to be one. I just looking for help if possible to use 1 query and no 3 for every report I make. If that makes me...
Forum: Reports 12-01-2008, 02:42 PM
Replies: 14
Views: 1,795
Posted By smile
Re: optimized way to make a report?

So based on everyone replies how unbound text boxes work and process data or should I say lack of replies I have made a decision that it’s better to have more queries since:

Access creates a...
Forum: Reports 11-30-2008, 02:10 PM
Replies: 14
Views: 1,795
Posted By smile
Re: optimized way to make a report?

BTW the delay can be seen if report opens in "report view" mode if I open it in "print preview" it seems to not have delay. Both open is same amount of time so anybody know?
Forum: Reports 11-26-2008, 02:20 AM
Replies: 14
Views: 1,795
Posted By smile
Re: optimized way to make a report?

Thanks I'll try that.

I don't understand the delay anyway. Why working with unbound controls in my case text box I get delay until code (I mean formula) is executed? Is this normal? Any methods to...
Forum: Reports 11-24-2008, 11:04 PM
Replies: 14
Views: 1,795
Posted By smile
Re: optimized way to make a report?

What about my problems with unbound text boxes on post 3, any ideas:

1. Unbound textbox takes 1 to 1.5 seconds delay to load on any report or form.

2. If I have unbound texbox 1 that creates...
Forum: Reports 11-24-2008, 07:51 AM
Replies: 14
Views: 1,795
Posted By smile
Re: optimized way to make a report?

My problem:

How to make calculations on report itself with unbound text boxes if that is the correct way to have 1 instead of 3 queries.

Ran into these problems:

read post 3.
Forum: Reports 11-24-2008, 07:46 AM
Replies: 14
Views: 1,795
Posted By smile
Re: optimized way to make a report?

Hmm, seems you have updated my sample db from another post. I see you got 50% where I'm now, you filter data by using query "group_code_bjw" then sum by code "total_code".

In my db for now I work...
Forum: Queries 11-23-2008, 03:51 PM
Replies: 3
Views: 2,413
Posted By smile
Showing results 1 to 25 of 212

 
Forum Jump



All times are GMT -8. The time now is 12:03 AM.


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

Featured Forum post


Sponsored Links


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