Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 500
Search took 0.11 seconds.
Search: Posts Made By: theDBguy
Forum: Reports Today, 02:57 PM
Replies: 6
Views: 89
Posted By theDBguy
Re: I'm missing something REALLY simple!

Hi. Glad to hear you got it sorted out. Good luck with your project.
Forum: Forms Today, 01:44 PM
Replies: 5
Views: 91
Posted By theDBguy
Re: Code help with Forms

Hi. For Problem #1, I must be missing a step. Here's what I did:


I opened your database and the F_Project form automatically opens up
I click on the Add New Project button and the form goes...
Forum: Reports Today, 01:27 PM
Replies: 6
Views: 89
Posted By theDBguy
Re: I'm missing something REALLY simple!

Hi. Are you saying [field1] is a Text field? What about [sainx]?
Forum: Forms Today, 11:58 AM
Replies: 5
Views: 91
Posted By theDBguy
Re: Code help with Forms

Hi. See if this does what you need.
Forum: Macros Today, 10:31 AM
Replies: 5
Views: 68
Posted By theDBguy
Re: Insert with Where Statement Not Working

Congratulations! Glad to hear you got it to work. Good luck with your project.
Forum: Modules & VBA Today, 10:16 AM
Replies: 4
Views: 74
Posted By theDBguy
Re: Access emails without outlook

Hi Colin. Thanks. I'll take a look.
Forum: Macros Today, 10:14 AM
Replies: 5
Views: 68
Posted By theDBguy
Re: Insert with Where Statement Not Working

Hi. You could try something like:


INSERT INTO table1 SELECT * FROM query2 WHERE ID Not In(SELECT ID FROM table1)
Forum: Modules & VBA Today, 09:11 AM
Replies: 4
Views: 74
Posted By theDBguy
Re: Access emails without outlook

Hi. I could be wrong; but if you're sending out HTML emails with embedded images, then I think those images may have to be hosted on a web server somewhere.
Forum: Queries Today, 08:53 AM
Replies: 15
Views: 195
Posted By theDBguy
Re: Non updateable check box

Hi. Could you put a transparent button on top of the check box? Just a thought...
Forum: General Today, 08:16 AM
Replies: 19
Views: 223
Posted By theDBguy
Re: Trouble with my end result

Hi. The bottom line is this - when you design a report, you tell it how many columns to show and where to get those information from. But, if the source of the report is changing dynamically, then...
Forum: Modules & VBA Today, 08:05 AM
Replies: 30
Views: 412
Posted By theDBguy
Re: run-time error 449 Argument Not Optional

Hi Jessica. Pardon me for jumping in, but have you tried stepping through the code during execution to examine all variable contents and see if it's doing what you're expecting? Just curious...
Forum: General Today, 07:59 AM
Replies: 19
Views: 223
Posted By theDBguy
Re: Trouble with my end result

Hi. Not necessarily that you did something wrong but more like you expected Access to work in a way it can't. If I were you, I would leave the query without a criteria and simply open the report with...
Forum: Forms Today, 07:48 AM
Replies: 5
Views: 82
Posted By theDBguy
Re: Update Details on a Form as I cycle the items on the datasheet

Ooh, I was looking for that but couldn't find it, so I ended up downloading the attachment instead. Thanks!
Forum: Forms Today, 07:47 AM
Replies: 5
Views: 82
Posted By theDBguy
Re: Update Details on a Form as I cycle the items on the datasheet

Hi. Good point. Okay, I looked at your db, and there's an easy fix for that. Take a look at the attached modified version of your db and let us know if this works for you.
Forum: Introduce Yourself Yesterday, 05:22 PM
Replies: 4
Views: 106
Posted By theDBguy
Re: Hi everyone!

Hi Jess. Welcome to AWF!
Forum: General Yesterday, 01:04 PM
Replies: 19
Views: 223
Posted By theDBguy
Re: Trouble with my end result

Okay, that makes sense. See the attached modified version of your db and open the report.
Forum: Forms Yesterday, 12:54 PM
Replies: 8
Views: 132
Posted By theDBguy
Re: Form Colour Background

Hi. You simply add a column to store the color and bind the combobox to it. You can then use code or CF to change the back color based on the value in the column/combobox.
Forum: Reports Yesterday, 12:33 PM
Replies: 12
Views: 153
Posted By theDBguy
Re: Print the current record in a report using a form

Hi. There are a few ways to handle this. For your case, it might be easier to create a query based on table2 but with a criteria based on form1. You can then use this query for report1.
Forum: General Yesterday, 12:23 PM
Replies: 19
Views: 223
Posted By theDBguy
Re: Trouble with my end result

The only thing I could think of is double-check your Sortie table and make sure there are no missing values in either the Annee or Mois column.
Forum: General Yesterday, 12:18 PM
Replies: 19
Views: 223
Posted By theDBguy
Re: Trouble with my end result

Yes, it worked for me.


https://access-programmers.co.uk/forums/attachment.php?attachmentid=78505&stc=1&d=1579724273

...
Forum: Introduce Yourself Yesterday, 12:12 PM
Replies: 3
Views: 63
Posted By theDBguy
Re: new user

Hi. Welcome to AWF!
Forum: General Yesterday, 11:58 AM
Replies: 19
Views: 223
Posted By theDBguy
Re: Trouble with my end result

Hi. Thanks. I added a parameter prompt to your crosstab query's design; unfortunately, it doesn't matter what client number I enter, I don't get any errors. Am I doing it correctly?
Forum: Forms Yesterday, 11:53 AM
Replies: 8
Views: 132
Posted By theDBguy
Re: Form Colour Background

Hi. To "persist" something, you will have to "store" it in the database, probably in a table would be the simplest approach.
Forum: Forms Yesterday, 11:52 AM
Replies: 3
Views: 94
Posted By theDBguy
Re: Form using multicolumn multiselect listbox to add rows to a table

Hi. You seem to be using the Column() property correctly, just remember it is zero-based. Other than that, you may have to post a demo version of your db, so we can take a look why it's not working...
Forum: General Yesterday, 11:40 AM
Replies: 19
Views: 223
Posted By theDBguy
Re: Trouble with my end result

Yes, if you can do that, I think it would make things easier.
Showing results 1 to 25 of 500

 
Forum Jump



All times are GMT -8. The time now is 04:32 PM.


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