Search results

I have a CompanyList table that exist on my local database and on a remote SQL Server database This table has the following columns: CompListRefID,CompanyName , State I created a query which compares what records that have been added in the local vs the remote table. What I want to do is any...

Thank you Pat, your response was detailed enough for me to understand now. Cheers!

Hi Galaxiom, I appreciate your reply but it was a bit over my head on how you resolved the issue. But what I did end up doing and it appears to work is that instead of defining the recordsource of the subform in code (which refers to a remote link database table). I defined the recordsource in...

Hi Pat, I am not sure what you mean using NO code. Can you explain it to me in more detail? Are you referring building queries in code is not advisable? Also, the Where SQL statement part has a variable I define in code. e.g. endMonth I am not sure how I use this without code.

Now I have changed it where I have the remote table linked and this is my revised code: Private Sub CompanyHistoryByPeriodTransactions(ContainerSubFormLabel As Label, ContainerSubForm As SubForm, ContainerSubFormObject As String, passQuery As String) Dim db As DAO.Database Set db =...

Okay, I'll try linking instead and see what happens. I guess, and I must have read and misunderstood the thought process of using passthrough on remote database tables. I am not using specialized SQL syntax. Thank you for the follow ups. But I know it still perplexes me the big difference...

Pat, my passthrough query, queries a remote server not locally on our network. Shouldn't I use a passthrough so I can use my t-sql statements on a table that resides on a remote server? I guess, I am wondering prior to the split, passthrough is fine but after the split, it is slow.

Prior to splitting the database, my PassThrough query performance was acceptable. After splitting the database, my passthrough query has become sluggish and slow where my users are not very happy. When I run a test prior to splitting my database, it would take about 1-5 seconds to retrieve...

I have created an .accdb file in Access 2010 and split the databases. I then created a .accde file in Access 2010. Now I found out that a couple of my users who want to use my .accde file has Access 2007 on their computer. They cannot open my .accde file. How do I create a file so my Access...

Thanks for your reply. I did a few of those suggestions. I knew there was a couple of more that I missed.

Anybody care to add suggestions?

Just doing a quick lookup here are a few steps I have done so far. Open for suggestion and other tips as I continue on. Create an new accdb file importing all contents from the .mdb file Hide the navigation pane and ribbon bar Split Database so I have an .accdb and *_be.accde file Create...

I have inherited a .MDB file. All of my users are on Access 2010. Can someone point me a reference area where I can prevent the USERS from manipulating the tables, queries, forms and macros and modules directly. All I want them to do is access forms and do the data entry from there. Thanks.

That makes perfect sense. I appreciate the replies as I get a better understanding programming. This helps. I will make my modification accordingly.:)

When is it necessary to use QueryDef stuff instead of using what you suggested.

I didnt know that. I missed the RED color indicator originally. Thanks.

Mark, thanks for the followup suggestions, I know it looks like a mess trying to read it, I will reformat similar to what your are suggesting...which I am sure other posters chiming in where saying something similar.

Wow, thanks for all those suggestions, very helpful and stuff I can add for my coding techniques. As for your comment Could you explain more in detail? Thanks again.

Hello, pbaldy, Could you explain in detail on what you mean by this? an example on the correct usage? I did it my way because in the past when I wrote SQL strings, I tend to mess up by not adding a space or mistyping something and it was easier to comment sections of the SQL string to find out...

Well after looking at this again, I pulled this piece of code off another form, which I think orginally, I was going through some form controls to make sure the required form control was populated correctly...whether previously I was making sure a dropdown boxes had values and Radio Options had...