Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 500
Search took 0.14 seconds.
Search: Posts Made By: theDBguy
Forum: Introduce Yourself Today, 05:22 PM
Replies: 2
Views: 45
Posted By theDBguy
Re: Hi everyone!

Hi Jess. Welcome to AWF!
Forum: General Today, 01:04 PM
Replies: 15
Views: 146
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 Today, 12:54 PM
Replies: 5
Views: 74
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 Today, 12:33 PM
Replies: 2
Views: 32
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 Today, 12:23 PM
Replies: 15
Views: 146
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 Today, 12:18 PM
Replies: 15
Views: 146
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 Today, 12:12 PM
Replies: 3
Views: 43
Posted By theDBguy
Re: new user

Hi. Welcome to AWF!
Forum: General Today, 11:58 AM
Replies: 15
Views: 146
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 Today, 11:53 AM
Replies: 5
Views: 74
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 Today, 11:52 AM
Replies: 3
Views: 59
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 Today, 11:40 AM
Replies: 15
Views: 146
Posted By theDBguy
Re: Trouble with my end result

Yes, if you can do that, I think it would make things easier.
Forum: General Today, 11:27 AM
Replies: 15
Views: 146
Posted By theDBguy
Re: Trouble with my end result

Hi. No worries. Thanks for the clarification. Can you please post the SQL statement of the query that's producing this error?
Forum: General Today, 11:17 AM
Replies: 15
Views: 146
Posted By theDBguy
Re: Trouble with my end result

Hi. It would have been nice if you translated the error message in English for some of us who don't speak your language. Since you posted an image, I couldn't even copy and paste it into Google...
Forum: General Today, 11:07 AM
Replies: 9
Views: 91
Posted By theDBguy
Re: Database Splitter

Hi. Congratulations! Glad to hear you got it sorted out. Good luck!
Forum: Queries Today, 10:11 AM
Replies: 1
Views: 35
Posted By theDBguy
Re: How to merging two MS Databases

Hi. Access or Tableau can connect to other data sources. So, if you want to create a 3rd db, you could simply connect it to your other two dbs. Or, you could skip creating the 3rd db and simply...
Forum: Introduce Yourself Today, 09:41 AM
Replies: 2
Views: 33
Posted By theDBguy
Re: New Member Introductions

Hi. Welcome to AWF!
Forum: General Today, 09:34 AM
Replies: 9
Views: 91
Posted By theDBguy
Re: Database Splitter

Hi. Welcome to AWF!


Are you able to post an unsplit copy of your db? We could try splitting it for you.
Forum: Queries Today, 09:32 AM
Replies: 4
Views: 65
Posted By theDBguy
Re: Non updateable check box

Hi. Bottom line is you cannot update a "calculated" column. So, you could add a separate control (checkbox) and use code to perform the actual update. Or, perhaps, just add a bound checkbox to the...
Forum: Queries Today, 09:22 AM
Replies: 9
Views: 107
Posted By theDBguy
Re: Strings to Exponent values

Hi. Is the first character/digit still represent the floor? If so, then maybe you just simply use the field as a sort field without using Val(). Have you tried that? Just curious...
Forum: Forms Today, 09:17 AM
Replies: 1
Views: 30
Posted By theDBguy
Re: Update Details on a Form as I cycle the items on the datasheet

Hi. I haven't looked at your db yet but just wondering if you have tried/considered using a Split Form?
Forum: Introduce Yourself Today, 08:04 AM
Replies: 3
Views: 46
Posted By theDBguy
Re: Hello from Idaho!

Hi. Welcome to AWF!
Forum: Forms Yesterday, 06:45 PM
Replies: 2
Views: 69
Posted By theDBguy
Re: How to copy a record and save as a new record.

Hi. You could try using an APPEND query.
Forum: Forms Yesterday, 06:26 PM
Replies: 14
Views: 186
Posted By theDBguy
Re: Conditional Formatting in Multiple Record subform

Hi Micron. Check out the image I posted on this previous thread (https://www.access-programmers.co.uk/forums/showthread.php?p=1648391#post1648391) and please imagine the buttons with the up and down...
Forum: Modules & VBA Yesterday, 02:33 PM
Replies: 10
Views: 141
Posted By theDBguy
Re: Pull string from in between characters

Hi berkdad. Welcome to AWF!

If you're looking for someone to hire, maybe I could help you. Please send me an email (link below) if you want to discuss it as a possible option for you.

Cheers!
Forum: Forms Yesterday, 02:20 PM
Replies: 14
Views: 186
Posted By theDBguy
Re: Conditional Formatting in Multiple Record subform

Hi. Since Conditional Formatting doesn't work with Checkboxes or Buttons, I tend to use Textboxes to simulate them and then use code to perform the action the original controls were supposed to do.
Showing results 1 to 25 of 500

 
Forum Jump



All times are GMT -8. The time now is 07: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