Search results

RE: Compaction (FE) Well I've (only just) rebuilt my FE from scratch, only importing the (small) tables to the FE, manually copying everything else (copied SQL into Queries), manually copying object names (queries, forms, & reports). I imported and copied in this order: Tables, Queries...

Inapplicable. I have the USB drive in my local laptop USB port, and I'm the only one that uses it. And besides we're all using Win10, SMB v1 disabled by default.

Yes, and defined. Like I said, it works without "Option Explicit". I am working with a 15+ yr. old database (updated and enhanced). This code was there back then, so I just reused it. I will try replacing it with acFormAdd. Looking at the AcFormOpenDataMode enumeration I see that acFormAdd =...

I have vba code, in a form, that opens another form in add record mode, that works fine until I try to add "Option Explicit": DoCmd.OpenForm stDocName, , , , acNewRecord, , StOpenArgs It doesn't like "acNewRecord". The problem is, looking at the OpenForm syntax, I cannot find an enumeration...

Thank you for your responses. I had already made a new database and imported all, so already did that. And my colleague tells me that she does not have the problems with database corruption that I do when working remotely (but she also doesn't use much vba - if any). I was hoping to avoid this...

Yeah, I think that's what they did last January, when my computer was updated (replaced) to Windows 10. The database went very flaky and I had to complain about it, they did something on the net and all is good now. I think we are getting derailed from the main complaint here, I am not having...

Oh yes, I use that location for other users so I can update them dynamically. Personally I use (and modify/update) a copy elsewhere. It is a management issue. I just restore either FE from my backups if it gets corrupted in that location.

The best way to go about this might be to use the button to activate a Query. Can this be written in a query? If not, then you would need to open a recordset and process it with vba (then close it).

Oops, just one little hitch to my last: I converted this db to Access 2016 from Access 2000 format in February, so I can only go back that far.

Yes, that is correct. I've personally either written, modified, or checked all the vba in the db (FE, the BE only contains tables). I would remember if any said anything about compact. And it happened just a while back - don't know exactly because I didn't watch the status line when closing in...

Hi dbGuy, well let me answer each point. 1. The db FE is located in a location for all users to access, but I have my own copy on my own drive, which is also a intranet network location - we cant use local drives, they are locked down. I am the only one that uses my FE 99% of the time, it is...

Hi all, I now have a very minor issue with my database. It is a large split-database, on an institution server, with two front-ends for two institutions who share the back end. I have completely reworked and improved the front-ends, adding a lot of functionality and procedure checks. Only one...

If you are using vba to set the filter, try adding: MyForm.AllowAdditions = False when turning on the filter, then if needed, use same to turn additions back on after turning off the filter.

Do you want a text, spreadsheet, or db table log? Here's what I would do for a text log: 1. Make a text file (it can be empty). 2. Use a print button with code like this: Private Sub Print_But_Click() On Error GoTo Err_Handler Dim intFileNo As Integer Dim txtFileName As String, LogMsg As String...

You need to run a separate query for each field to do that that way.

I see two recordsets: rs_calcmed and rscalcmed. I don't see where rs_calcmed comes from (no recordset open, no declaration of Access object type - table or otherwise). Could this be a typo?

Personally, I don't like working with date strings, there is just too many possible ways to screw that up. Here's what I do. Format the textboxes as some sort of date (short date?), unbound. Set the start date validation rule: ([Start_Date] Is Null) Or ([End_Date] Is Null) Or...

GTK, thank you.

Have you declared "Option Explicit" at the beginning of your module? I see you have declared several variables as 'Public.' I suppose you are aware of the dangers of using 'Public' variables? Now to that subject, I see no declaration for the variables credit1 and credit2. Are they Textbox...

Yes, this is SOP to debug code.