Search results
-
Dynamically Change Recordsource of a Subreport
Congratulations!- theDBguy
- Post #4
- Forum: Modules & VBA
-
Dynamically Change Recordsource of a Subreport
No guarantees but the using the Detail Format event to manipulate the subreport.- theDBguy
- Post #2
- Forum: Modules & VBA
-
-
-
Solved Troubleshooting Subform
I tried to see what's going on with your forms, but it's taking too long, so I decided to test it with a new form, which seems to work. My guess is maybe your form got corrupted. Just my 2 cents... -
Solved Troubleshooting Subform
If not too troublesome, you might consider posting a sample db to demonstrate the problem. -
Solved Troubleshooting Subform
Does the main form also go to a new record or just the subform? -
-
-
-
Other user can't open SQL Table in Access
I was about to suggest/recommend trying a DSN-less connection. :)- theDBguy
- Post #17
- Forum: SQL Server
-
-
-
-
Solved Conditional formatting for date and text field
Instead of assuming the previous record is only 1 value before the current one, you could search for the highest autonumber value that is less than the current one. -
Solved Conditional formatting for date and text field
Glad to hear you got it working, but using -1 in your expression may not be reliable. Potentially, you could end up having gaps in your Autonumber fields and -1 will end up failing. Just a thought… -
Solved Conditional formatting for date and text field
Can you show us your CF expression? Are you using an Autonumber field as the primary key? Or, so you have a date field to help determine which record is the “previous” record? -
-
Query with heading and row and listing
Still only using my phone, so can’t see what Arnel provided, but I have a feeling it would include a similar function if it was needed. If you’re still curious to see what my function looks like, you can go to this link. SimpleCSV() -
Query with heading and row and listing
I can’t see all the sample data but maybe investigate using a crosstab query. Sent from phone…