Search results

I don’t understand any of the gibberish, it’s just a bunch of things equaling random letters and numbers

It just returns a bunch of gibberish...is it possible that it’s linked to more than one table in the DB?

With the linked table in Access, is there any way to look at what DB table Access is pulling from? I didn’t write the Access table code so I don’t know where it pulled from inside the DB

Ok, interesting. So in addition to the table itself, all the fields listed in the SQL must be the names of fields in the Oracle db table, not the access table. I’ll see what I can do, thanks.

Ok, I’ve made my code compliant with Oracle SQL. Now, when I run the code it says that the table or view doesn’t exist. In my select/from clause I’m using the MS Access table I’m wanting to pull from, similarly to how you choose “table” in a select query...any thoughts?

For security reasons I cannot post it. I created the query in Design View then converted it to SQL view so I wouldn’t think it would convert incorrectly.....I’m very unfamiliar with SQL code so I’m not sure.

Hi all, I’m trying to automate a query that requires a security login and password through ODBC. The internet said to use a pass-through query and showed me how to do the ODBC Connect Str in the Property Sheet. I saved the password to the string, but when I run it, it returns an error saying...

Yes that makes sense. I was just told that if I open the live file and edit it, the hit “save as” and save it somewhere not on the server, then the live one will not be changed. Can anyone fact check this?

It is a shared file, so would working in the copy-pasted file change the original if I were to save it?

yes it is a make table query. I’m currently working on a function to properly execute it. Side question, is there a way to create a dummy duplicate of my Access database so I can toy with functions and all that without messing things up in the one my boss uses? This process is vital so I’d like...

Where would I write the function to execute the query so that it can be run from the vbscript? Do I have to put it in a form or how does that work? And do I just put the function name into that script or is there a path that I have to include?

Right now in the criteria section of the query it states: >= [>= date] Are you saying it could just be: >= Date()-7 I could make a new identical query with that change as my boss sometimes like to run the query with a different date entered. I still don’t know how to automate the login and...

Great thank you. So I now need a procedure to automatically run the query and input the parameters, correct?

Can you put that in idiot language please lol I’ve been working with Access for about 2 days, VERY unfamiliar with how to do pretty much anything.

I see. Best example I can give is this. On 6/15 we ran the query and entered 6/8/20 so that we got all the data from the week before. I’m trying to schedule the query for 12:00am on a Monday morning and have the date be the Monday prior to get just the data from exactly one week. Does that help?

The date entered is the data from which we start pulling data. For instance if I put in 6/15/20, it pulls all the data starting at 12:00am on 6/15/20 up until the current time.

The two parameters are the date (we run the query weekly so the it’s the date to start pulling the data from) and a username and password. I’m very unfamiliar with Access and VBA, do you have any examples of what you mean?

Hi all, I’m new to forums so I’ll give it a shot. I have an existing parameter query that pulls data from a db. I want to create something to automatically run that query and automatically fill in the needed parameters. Eventually I will be putting all this into task scheduler to run this query...