Activity Stream - Microsoft Access Forums

Sort By	Time	Show
Recent Recent Popular Popular	Anytime Anytime Last 7 Days Last 7 Days Last 30 Days Last 30 Days	All All Photos Photos Forum Forums

Today, 02:33 PM

lefty2cox started a thread Declaring and setting object variables, or just plain referencing controls in Programming

I've been struggling with this for some time now. I have two big books, this forum and a dump truck full of internet reading and youtube videos under...

0 replies | 4 view(s)

Today, 01:46 PM

Gicu replied to a thread Grow a report section line issue in Reports

Have you tried this solution?...

1 replies | 14 view(s)

Today, 01:14 PM

tkosel started a thread Grow a report section line issue in Reports

I have a report with several groupings. The group section Header can grow property is set to true as well as several fields in each group section. ...

1 replies | 14 view(s)

Today, 12:52 PM

Micron replied to a thread IIF always causes syntax error when syntax is correct in Access

I guess not realizing that is the result of designing in a bubble of sorts. So what about a value list (control rowsource property)? Commas, not...

9 replies | 45 view(s)

Today, 12:23 PM

accesstos replied to a thread IIF always causes syntax error when syntax is correct in Access

Depending on the OS regional settings. In my case (Greek), the separator of the arguments in expressions for form’s controls and for query design...

9 replies | 45 view(s)

Today, 12:19 PM

Micron replied to a thread IIF always causes syntax error when syntax is correct in Access

That sucks. Posted here 11 days after excellent suggestions elsewhere and no courtesy link to the other forum.

9 replies | 45 view(s)

Today, 12:10 PM

Minty replied to a thread IIF always causes syntax error when syntax is correct in Access

Previously posted here https://www.access-programmers.co.uk/forums/threads/my-version-of-access-does-not-like-iif.316350 With a raft of suggestions....

9 replies | 45 view(s)

Today, 11:48 AM

Gicu replied to a thread IIF always causes syntax error when syntax is correct in Access

I think Carletto's regional settings are set to Italian which uses semicolon as a list separator. I suspect the OPs settings are also using something...

9 replies | 45 view(s)

Today, 11:34 AM

Micron replied to a thread IIF always causes syntax error when syntax is correct in Access

I also had no problem with the expression with a comma. In fact, I can't recall any built in function where the arguments are separated by...

9 replies | 45 view(s)

Today, 10:55 AM

d9pierce1 replied to a thread Private Sub Assistance in Programming

Thank you Gicu, I am trying my best to stay away from option groups as i have found they are hard to get a txt value from at times. In this case, it...

2 replies | 34 view(s)

Today, 10:46 AM

Welshgasman replied to a thread IIF always causes syntax error when syntax is correct in Access

I've never had to do that? SELECT Transactions.ID, IIf(>100,"Yes","No") AS Test FROM Transactions;

9 replies | 45 view(s)

Today, 10:42 AM

Gicu replied to a thread Private Sub Assistance in Programming

Not sure about your exact requirements\setup but you could replace the two fields Yes\No fields (,) with one called . Then bind that field to an...

2 replies | 34 view(s)

Today, 10:30 AM

d9pierce1 started a thread Private Sub Assistance in Programming

HI all, Trying to use more Private Subs and call to them to clean up a lot of useless code. Below is a Private Sub and I want to know is there a...

2 replies | 34 view(s)

Today, 10:30 AM

CarlettoFed replied to a thread IIF always causes syntax error when syntax is correct in Access

Using the Query Builder (QBE) window the comma "," must be replaced by the semicolon ";" then the expression becomes: Test: IIF (1 + 1 = 2; "yes";...

9 replies | 45 view(s)

Today, 10:19 AM

Micron replied to a thread IIF always causes syntax error when syntax is correct in Access

That's an odd one. I'd check the version and build number and see if Google tells me anything related. Updates have a way of introducing problems so...

9 replies | 45 view(s)

Today, 09:43 AM

MeeToo started a thread IIF always causes syntax error when syntax is correct in Access

My version of Access has a problem with understanding IIF in a query. Even something as simple as Test:IIF(1+1=2,"yes","no") triggers a syntax error:...

9 replies | 45 view(s)

Today, 07:04 AM

NoellaG replied to a thread Running VBA code before security warning in Security

Maybe a possibility: ask the IT guys to create a SQL (express) database with the proper securities set for your application, that you can link to...

20 replies | 3501 view(s)

Yesterday, 11:57 PM

pbaldy replied to a thread Query return zero counts in Access

Typically you would add the table containing the DeIDBased items, joining on that field. Edit the join to return all records from that table.

1 replies | 63 view(s)

Yesterday, 09:35 PM

Hursan started a thread Query return zero counts in Access

I have a query that returns all DeIDBased with at least one record, but I have some DeIDBased that have no records, I would like my query to return...

1 replies | 63 view(s)

Yesterday, 08:38 PM

davegri replied to a thread Changing Tables or Renaming in Database Design

Here's a little utility you may find useful. It will set up relational integrity links within a specified BE.

10 replies | 182 view(s)

Yesterday, 07:49 PM

NoellaG replied to a thread Oh So Lost!! Unable to Import or get past set up. in SQL Server

Hi, if you want to import data from access to SQL server the data source is Microsoft Acces. So you don't have to give a connectionstring, but a...

2 replies | 73 view(s)

Yesterday, 05:13 PM

lefty2cox replied to a thread Where Clause For Opening Forms in Programming

Awesome. Thank you. It worked brilliantly. So name of control field in form to open and then name of the actual control in the current form? There's...

3 replies | 85 view(s)

Yesterday, 04:51 PM

JonathanT started a thread Report Sorting on a calculated field in Reports

I have a report that has a RatePlan grouping. The grouping is sorted A-Z. The grouping includes a text box that sums the Amount field called...

0 replies | 38 view(s)

Yesterday, 02:45 PM

Gicu replied to a thread Where Clause For Opening Forms in Programming

In the Click (I suggest you use the DoubleClick event as the Click one is to easy to trigger by accident) of the txtSubID on the subform add: ...

3 replies | 85 view(s)

Yesterday, 02:39 PM

Welshgasman replied to a thread Where Clause For Opening Forms in Programming

The Where is like a WHERE clause just without the where So something along the line sof "ID = " & Me.ID where ID is the field in the table and...

3 replies | 85 view(s)

Yesterday, 02:31 PM

lefty2cox started a thread Where Clause For Opening Forms in Programming

I'm having a hell of a time creating this code. I want to open a form to a specific record by clicking on the ID (click event on the textbox) of a...

3 replies | 85 view(s)

Yesterday, 02:06 PM

June7 replied to a thread Oh So Lost!! Unable to Import or get past set up. in SQL Server

Try using SSMA - review https://support.microsoft.com/en-us/office/migrate-an-access-database-to-sql-server-7bac0438-498a-4f53-b17b-cc22fc42c979

2 replies | 73 view(s)

Yesterday, 12:55 PM

brigitteAT replied to a thread is there an easy way to link pdfs, mails to mdb ??? "drag and drop"? in Access

to me that doesn't sound like a sad but a very exciting job-story.. and if you want to carry on, don't be too modest! you have lots of experience in...

14 replies | 213 view(s)

Yesterday, 12:17 PM

Micron replied to a thread is there an easy way to link pdfs, mails to mdb ??? "drag and drop"? in Access

The only time I was employed as an instructor was in continuing education in basic photography (community college) for about 6 years. My primary job...

14 replies | 213 view(s)

Yesterday, 11:46 AM

brigitteAT replied to a thread is there an easy way to link pdfs, mails to mdb ??? "drag and drop"? in Access

Sounds as if you miss your teacher-job?!? according to what happens - or rather does not take place - in schools at the moment, I guess you have good...

14 replies | 213 view(s)