Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 500
Search took 0.22 seconds.
Search: Posts Made By: isladogs
Forum: Modules & VBA Today, 02:55 AM
Replies: 8
Views: 83
Posted By isladogs
Re: using text box inputs to use in your filename

One issue is the quote marks. Its just treating the contents as a string.
Omitting those, I think it will still fail if your dates look like 10/12/2019 even using .Value (though that can be omitted...
Forum: Reports Yesterday, 08:17 AM
Replies: 4
Views: 91
Posted By isladogs
Re: Text Boxes Height needs to match a given text box

You would use that in the On Format event of the report section where the textboxes are located
e.g. Detail_Format event

Obviously you would need to use the names of your own textboxes with the...
Forum: Forms Yesterday, 06:15 AM
Replies: 11
Views: 120
Posted By isladogs
Re: Update Code

Did you make the same changes in the other strSQL statement?
Do you have any number fields? If so, remove the single quotes for those.

Looking at the two statements, the WHERE line is different...
Forum: Forms Yesterday, 05:51 AM
Replies: 11
Views: 120
Posted By isladogs
Re: Update Code

As they are both date/time you need to use # delimiters instead of single quote '


"',Anruf_2 = #" & Me.txtAnruf_2 & _
"#,Anruf_3 = #" & Me.txtAnruf_3 & _
"#,
Forum: Forms Yesterday, 05:26 AM
Replies: 11
Views: 120
Posted By isladogs
Re: Update Code

What datatypes are the two 'problem' fields?
Forum: Modules & VBA Yesterday, 03:21 AM
Replies: 5
Views: 135
Posted By isladogs
Re: Compare table with imported table and find differences

As Bob said use an unmatched query (there's a wizard for this) to determine any new records. You can convert that into an append query to add the new records.
Then use an update query to update...
Forum: Tables Yesterday, 12:05 AM
Replies: 14
Views: 231
Posted By isladogs
Re: Problem in conversation of date

I haven't looked at your database but you could try adding Me.Recalc after running the update query.

However I still recommend that you don't save the calculated value. Just concatenate the other...
Forum: Modules & VBA 12-08-2019, 03:36 PM
Replies: 11
Views: 166
Posted By isladogs
Re: permissions denied error with CreateTextFile()

Saving to the root c:\ drive is restricted by default (and has been for about 10 years)

Here's an example of the message you get when trying to save to the root drive c:\
...
Forum: Forms 12-08-2019, 01:54 PM
Replies: 5
Views: 108
Posted By isladogs
Re: Creating a Form that looks like a monthly calendar to input employees work schedu

Here's one of the Peter Hibbs' calendar apps https://www.utteraccess.com/forum/index.php?showtopic=1969978&hl=Calendar

There are several others...i'll leave you to Google them yourself

DEMO...
Forum: General 12-08-2019, 06:00 AM
Replies: 2
Views: 63
Posted By isladogs
Re: Change sidebar large icons to small

Right click on the Navigation Pane header and click View By. Change from Details to List
Forum: Queries 12-08-2019, 05:33 AM
Replies: 49
Views: 9,024
Posted By isladogs
Re: IIF returns 0 instead of boolean

Unbound check boxes in Access can have a triple state where the third state is null. It appears as a black filled box.
However check boxes bound to Boolean fields can only be true or false.

In...
Forum: Tables 12-08-2019, 01:13 AM
Replies: 14
Views: 231
Posted By isladogs
Re: Problem in conversation of date

If you really must save the value in a field, you could use an update query or a calculated field

However. there is no need to save the combined data separately as you are just duplicating data....
Forum: The Watercooler 12-07-2019, 03:34 PM
Replies: 32
Views: 485
Posted By isladogs
Re: we seem to be getting more visitors lately....

Whether its a generation gap or not, I also find your continual use of shorthand both irritating and a distraction to the point you are trying to convey. Whether its 'prolly' or 'cuz' or 'u r' or...
Forum: Forms 12-06-2019, 08:26 AM
Replies: 7
Views: 109
Posted By isladogs
Re: Change BackColour of Form

Its in the Thread Tools dropdown
Forum: Forms 12-06-2019, 07:12 AM
Replies: 7
Views: 109
Posted By isladogs
Re: Change BackColour of Form

Yes you can but the expression is based on the field name not the control name.
Use Expression Is ...[FieldName] = some condition
You can apply the same formatting to multiple controls at the same...
Forum: Forms 12-06-2019, 02:45 AM
Replies: 12
Views: 114
Posted By isladogs
Re: Update table code

ZeidHadded
You may have noticed that I added code tags to posts #1 and #3 to make it easier to read.
Please can you do so for any future code using the # button on the edit post toolbar.
Forum: Introduce Yourself 12-05-2019, 08:59 AM
Replies: 6
Views: 99
Posted By isladogs
Re: Hi from Shropshire in the UK

Hi Greg.
We have many members at different levels of experience, both young and old.
Glad to have you join us....what took you so long?
Forum: Modules & VBA 12-05-2019, 02:40 AM
Replies: 37
Views: 573
Posted By isladogs
Re: Export data fields based on checkboxes on Form

So loop through with code similar to this to remove all double commas

Dim X As Integer, Y As Integer

StartCheck:
X = Len(strSQL)
strSQL = Replace(strSQL,",,",",")
Y = Len (strSQL)
If Y<X...
Forum: Modules & VBA 12-04-2019, 09:40 AM
Replies: 15
Views: 223
Posted By isladogs
Re: Login and User Access

Emma
See if you can make use of this example app Password Login with Session Login Info (http://www.mendipdatasystems.co.uk/password-login/4594469149)

Personally I wouldn't create two versions of...
Forum: Forms 12-04-2019, 02:00 AM
Replies: 10
[SOLVED] Which Event?
Views: 141
Posted By isladogs
Re: Which Event?

That's exactly what I meant though in fact this may work better

Private Sub ControlName_Change()
ControlName_AfterUpdate
End Sub

I've used this myself in a few places & it did the job!
Forum: Forms 12-04-2019, 01:52 AM
Replies: 10
[SOLVED] Which Event?
Views: 141
Posted By isladogs
Re: Which Event?

Add another _Click event as follows

Private Sub ControlName_Click()
ControlName_AfterUpdate
End Sub
Forum: Modules & VBA 12-04-2019, 12:14 AM
Replies: 37
Views: 573
Posted By isladogs
Re: Export data fields based on checkboxes on Form

To avoid overwriting the text file each time, you can include the current date in the file name. For example
"c:\ExportData" & Format(Date, "yyyymmdd") & ".txt"
or if likely to be repeated the...
Forum: Modules & VBA 12-03-2019, 06:49 AM
Replies: 2
Views: 103
Posted By isladogs
Re: Serialize Function Problem

The Serialize function doesn't play nicely with variables.
However its possible to work round this by populating a 'temp table' with the filtered data then running a rank order query on that

The...
Forum: Modules & VBA 12-03-2019, 01:04 AM
Replies: 4
Views: 2,121
Posted By isladogs
Re: How do I used Stephen Lebans / Peter Schoeders serialize function

See my thread in the repository complete with an example app https://www.access-programmers.co.uk/forums/showthread.php?t=297922

If you need more help, please start a new thread of your own.
Forum: Modules & VBA 12-02-2019, 10:03 AM
Replies: 16
Views: 190
Posted By isladogs
Re: Import CSV with Windows File Prompt

FYI, no additional references are needed to run the File Dialog.
It is part of the default Microsoft Access xx.0 Object Library automatically used with any new Access ACCDB database
Showing results 1 to 25 of 500

 
Forum Jump



All times are GMT -8. The time now is 07:49 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 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World