Search results

Now that i have the Datasheet staying where it should, when someone Save's and Close's it does not update on the datesheet :( Can i get any help with that?

Thanks JHB, was it the embedded macro causing it? If so its strange because i got the embedded macro from the NorthWind database (Customer List), and when the customer form was closed in the Northwind Database the datasheet did NOT go back to the first record. Would love to know what was...

Hi all, I posted yesterday about getting some code to select a record on a datasheet HERE This was because when i create or edit a record then close the form it goes back to the top of the datasheet. In my thread (above) MarkK kindly gave me some code, but told me this is not the Datasheets...

Thanks Mark, before I try the code I will try and figure out why the datasheet refreshes when I close the form. If this is not normal behavior I should be able to figure it out (I hope lol). Thanks again Chris

Hi all, I have a 'main' form which has a datasheet displaying all records (Form1). And a form for Creating or Editing records (Form2). When form2 is closed the Datasheet on Form1 refreshes and the record at the TOP of the datasheet is selected by defualt. What i want when Form2 is closed is...

Hi June, Thanks for your reply. I am just testing something out now. I have put an invisible textbox on a signle form and on load i use the following If Me.NewRecord Then Call NewRecordActions Else Call ExistingRecordActions End If The subroutines in the above determine what...

Hi all, I am wondering if how i am doing things is the best way. Basically i always have two forms:- NewRecord - for when someone clicked to create a new record ViewEditRecord - opens the record that is clicked in the Datasheet I do this because the New Record generates the Created By and...

Thank you Ranman256, i will try adding an 'On error goto' that will Quit if there is any errors.

Hi all, I am having a problem. I have some code that takes a copy of the Master word document from a shared drive, then puts it in the users Documents. Each time it does this it KILLS the old version so that the user is always using the most upto date Master version. The reason i take a copy...

Hi all, I have created a tool in Access to generate letters from data in a SQL Server which is working fine. However, there is 10+ users of this tool and only 1 Word Document on the network drive. I have a problem with the Word Document, SOMETIMES its does not close down properly and I have to...

Hi all, I have created a database which has been working perfect for all users. However now there is more people using it i have come acroos a problem with people who have notebooks laptops. The problem is that the popup form is to big for their screen so they cannot use the bottom half which...

Thanks Ranman, but this just pulled out records where all fields were null. This is what i wanted. Thanks CJ.

Hi all, I have a query with 11 fields. Is there a way i can check if any of the fields in a row is blank? I was wondering if a count would work in some way? Thanks in advance Chris

Thank you for your reply. I have found something really strange. I have built the front end to hide all the objects and menu's. In the Options/Current Database i have the "DISPLAY FORM" set to my main form. When i turn this off to display (none) the file size drops 10mb.

Hi Minty, Yes, i keep an eye on the file size as a run it too. The file size goes to 11mb but when i come out out of the front end it goes back up to 16mb :(

Hi all, I have a database which i have just moved to SQL sever but still using Access as the front end.. When the data was in a back-end on a shared drive the front-end file size was 3mb. For some reason now my back-end is SQL server the file size has increased to 17mb. I am trying to find...

THis is what i am going to do not that i have established that my data is loading slow due to the back-end database being on a slow network drive :)

You have just given me the anser to why it is slow. The data tables are in a backend database that is on a network drive which is pretty slow. I am currently trying to learn how to get the data to go onto a sql database that our IT department have set up for me. So i think this is what i need...

Hi pbaldy, Thank you for your reply. I have Access 2016 and i have just tried to add the above IFF as a calculated field but i get the following error "The expression IIf([Date Closed]<=Date(),"Closed","Open") cannot be used in a calculated column.

Hi all, I have a query which determines if a case is open or closed by the closed date (some close dates could be in the future) I am guessing having this as a field is slowing the data when loaded IIf([Date Closed]<=Date(),"Closed","Open")) AS [Case Open/Closed] I would prefer this to be...