Search results

Hello Pbaldy, I believe I figured out what was causing the data to not populate. I was not aware that you must save your changes before rerunning the query. For example, the database was only recognizing the last date parameters save. Once I change the date parameters, save, then rerun the...

Hello. Can someone explain why my Dsum formula does not work when I change the date parameters to a different year? For example, the following formula "(DSum("[Eligible Wages]","[401K Report - Dina Detail w running totals]","[Employee ID]='" & [Employee ID] & "' and [Pay Group]='" & [Pay...

Hello sxschech, thank you for the speedy reply and your remedy work! Once again thank you for helping me resolve my problem.

Hello, can you help me resolve my problem? I created a form with a command button that will open a query. However, my objective is to open the query then filter based on the end user group. For example, I have the follow code: DoCmd.OpenQuery "HrOwner", acViewNormal, acReadOnly...

Hello, unfortunately I am unable to get my split database to work on end users' local drive. The error message received is a run time error 3044 stating the path the back end is stowed is not a valid path. I need help ASAP. Thank you in advance.

All users/countries were provided a network path to access the database.

Hello RuralGuy, all end users were granted read/write permissions to a shared network folder.

Hello and thank you all for the recommendations. I was able to split the database and moved the front end to the shared folder. However, my next step/question, how can I send each user a copy of the front end without breaking the links and maintaining the security permissions in addition to...

Hello RuralGuy, yes the compact and repair was executed and unfortunately that did not resolve the problem. I watched one user attempt to access the database and the first thing I noticed was how long the database took to respond. I've since then engaged IT to trouble shoot the timing issue...

Important points: Is the database split Do all users access (ie use) a distinct copy of the front end database. How does the German user connect to the database If you are all sharing the same copy, and you have a foreign user sharing the same copy, then this is likely to be the cause. Hello...

Hello, can anyone explain why access creates a backup file when end users are attempting to access the database? For example, the end user is from Germany and trying to access a shared folder that contains the database and each time she attempt to access the database a serious of errors appear...

What if the columns are not consecutive? For example, address 1, update address 1, address 2, update address 2, ......etc? Thanks.

Arnelgp, the previous code added special characters at the end of each address. Any insight on what is causing this? See below: 25 W Mystic AveÿMystic, CT 06355ÿY The yY are the special characters. Thanks.

Arnelgp, finally I was able to get the code to run without errors. What was causing the previous error was the * Len(strContent)-1). After removing the -1, the code ran without any errors. I am currently checking the results to see what impact the -1 have on the results. Thank you.

sneuuberg, I received the following error: Run-time error 3883 The calculated column contains an invalid expression: If IsNull(rs.Fields(i).Value) And Not IsNull(rs.Fields(j).Value) Then Thanks.

Hello Arnelgp and thank you for your contributions. However, I received the following error message after I posted and change the applicable fields to fit my need to a module. Run time error '5': Invalid procedure call or argument on strContent = Left(strContent, Len(strContent) - 1) Thanks.

Hello sneuberg, thanks for posting and excuse my ignorance due to my level of coding. After the code is populated in my database, what can I expect to see? Is there something I have to change in the coding? Thanks for being patient as I increase my level of coding.

Hello Sneuberg, yes providing structural coding to use will be very helpful. Thanks.

I am exporting the data from an external source and the inconsistency I think come from extracting from a global source (HRIS application). Thanks.

Hello, I am currently using ms access 2013 query function to provide a demographic file to an external vendors. I am struggling with compiling address information based on the 3rd party’s criteria. Unfortunately, the end users populating the source data is not following any particular format...