Search results

No, you're definitely right. If I was to start over I'd certainly be designing it that way - unfortunately I started building this system which I was 17 and rather inexperienced - there is so much I would fix, but we're slowly retiring different modules within it into other hosted solutions, so...

Great idea!!

Gone from 2gb down to 0.8gb! I think the old BE is just corrupt and couldn't compact because of that one corrupt table. Thanks all. Repointing the FE now so hopefully no problems..

Good idea, not sure why I didn't think of that. I know the offending table so I can export every table bar that one, hopefully then compact the new table if necessary, and use that. I assume I'll then need to re-link all of the tables from the FE to the new BE...

Hello I have an access dB that stores meeting minutes as attached documents. This has caused the databas (I think this is why at least) to reach the 2gb limit. Ive moves 50% of the records to a backup dB to hopefully reduce the size. I’ve then tried decompiling and compacting however it makes...

Hi all, So the task in hand is that I need to email an encrypted xlsx sheet to a predefined party from Access. I figure this is not possible to do immediately in access, but I thought it'd at least be possible to export an encrypted file. At the moment, all I can do automatically is export...

Sorry - I'm not sure this is quite what I'm looking for - thank you though. I'm looking for a simple line of code to hide document tabs (It must be possible, everything is, right?!) ;)

Hello Thanks very much for this, are you able to break it down for me to which part, each bit of the code does? I'm a little pedantic about needing to know exactly what each piece of code I use is as if I ever need to fix anything, I have to do it almost instantly due to the uses of this DB...

Hello I'm wondering if it is possible to create a module to hide the navigation pane and document tabs? I know this is possible via the Access Current Database options however I'd prefer this to be done via an Auto Exec that runs the sub. (i already have it for the ribbon) Also, the code to...

Changing the way I manage whether they are active/inactive. There will now be a status field in the AgentList table and every query will provide only Active agents... Hopefully it wont be too slow!!

Hi Pat, Thanks for the reply, thats correct, it is the default name and I didnt change them! Cheers.

Perfect - thank you for your help!

Hello It appears to be working now (there were some 'Error' or blank values). Can you just explain what that function says for me so I know in future and can change it if I need to? Thank you so much for your help!

Weird. Its fine in every other query. Renamed to [ShiftDate] and still the same error.

Hello I havent fully verified (Will be testing the data shortly) but seems to be perfect, thank you very much! I am now creating a query based on this query that is a cross tab. SQL Below. I'm getting the Data Type Mismatch in Criteria Expression error however I have no criteria...

Like "*" & [Forms]![Navigation Form].[Form]![NavigationSubform].[Form]![NavigationSubForm].[Form]![SearchCallbacks]![Surname] & "*"

Looks great, thank you. How would I refer to this in the query? Currently.. SELECT Timesheets.Agent, Timesheets.Date, Timesheets.[Exact Shift Start], Timesheets.[Exact Shift End], Timesheets.[Lunch Duration], Timesheets.[Lunch 2 Duration] FROM Timesheets;

Hello I'm not great with VBA so I've been trying to figure out a way to do with with expressions and welcome your feedback! I have a timesheet database, which has the exact start time and exact end time. I want to ignore this if it is five minutes either side of the half hour, and display...

Any suggestions?

Any suggestions?