Search results

Data. I need to edit some values.

Hi all, I need to update a table at a client's site to change a couple of fields, and would like to be able to send them something that they can run on their end to perform an insert query. I cant update the tables via RDP etc. because the database needs to be in Access '97 format, and they all...

I've taken over a database written in Access '97 so it's quite old and I don't want to rewrite the whole thing. I have a query as the record source for a report like this: SELECT TOP 1 ID1Child5.ID, ID1Child5.CODE1, ID1Child5.CODE2, ID1Child5.CHARGE, ID1Child5.DEFAULTS FROM ID1Child5 WHERE...

You would need to either show / hide the answer forms if you are using multiple choice. For a text field you would compare what they type in to whatever you have in the backend as the answer and this can be the same for each question. (tho the question itself would need to show / hide) this is...

Nevermind, I just set it as a make-table query and using the table a recordsource is a good workaround.

Let me clarify, the query doesn't include "rows" that should not be present, the query looks great when I view it. But when that VBA code runs, what I am seeing is data in a field called "max" is incorrect. I am not using the Filter condition in SQL, I am using other queries to calculate this...

Hi, I have what seems to be a pretty complicated issue so I'll try and explain it as best i can. I have a query (that gets it's data from several other queries) with a column called "max." The data in the column is correct, but when I call on the query in VBA, it shows me incorrect data. Here...

This is an old post, but I thought I'd add in how I was able to set my reports to print in duplex. Without any VBA. -Open report in design view -Click office button > print -Click properties > change to 2 sided -Click OK > this will print out the report -Manually save the report, because I...

Not being an Access jedi or anything, what I do in these cases is import external data > access > and choose the updated tables. This imports a copy with a "1" at the end so i have to delete the old one, rename the new one, and redo any relevant relationships. This is handy if I have updated...

Thanks for your replies. I would use a front end table for this one since everything is front end and the database is accessed from the network (this may change in future) and if these variables are ever going to change, then they should change for everyone at once. So i fi use a table, could...

Hi, I have a database that creates many forms based on queries which are based on user-defined variables. These are permanent variables added directly in the query, such as "if an employee is late 4 times in a month, we yell at them." I would like to be able to change this to "5 times in a...

Yes, I know it's specific to the machine. Not being very familiar with this process I didn't know how to "share" a connection. Anyways, I set up a file DSN and put it on the network, works well. Thanks.

Hi, In my database, I have 2 ODBC connections to a SQL database to pull data each month. Am I able to set these up so that the end users will not be required to set up the ODBC data source? I've checked the box to save the pwd on the link in Access, but it still only works from my computer...

I know that it isn't usually best practise to store calculated fields in a table, but in my situation it is necessary, and I haven't really found a good answer for this after searching these and other forums. Currently my database has one "Name" field (I didn't make it like this) which might...

Thank you! I am not all that good at queries etc. This worked great..

Let me explain, sorry I wasnt really thinking typing that. The "Actions" table is imported from a seperate db and does not include the "ID" field. The "Name" field is not a name as such, but their username on our POS system which i likely going to always be in that format of last, first. I have...

I am importing and appending locally. The data looks like this (for example): name; action; ID; datetime jones, bob; late; 1;, ## jones, bob; error; 1; ##

I have a find unmatched query that imports new actions. I think maybe we are talking about different things, I'm not asking how to add new actions onto that table. I am trying to get the tables to relate to each other. I need some kind of loop that will go through the actions table, look at...

Yes, though i dont see it being relevant for my current purposes.

No, they don't match. There are no duplicates tho. For unmatched names (such as new hires) I will create a manual process to update these.