Search results

Hi Guys, i have 2 tables: Table1 ID Pet Kind Color 1 Cat Mammal Black 2 Dog Mammal White and Table2 Table2 ID Food 1 Fish 2 Meet What i want to do is to get result like here: ExpectedResult ID Pet Kind Color Food 1 Cat Mammal Black Fish 4 Cat Mammal Black Meet 5...

Hi, i have query like here: SELECT DeploymentName.Deployment, DeploymentName.Profile, Table2.ResultTable2, Table1.ResultTable1 FROM ((DeploymentName INNER JOIN Profiles ON DeploymentName.Profile = Profiles.Name) LEFT JOIN Table2 ON (Profiles.TableProfile = Table2.Name) AND (Profiles.TableName...

Hi Guys, long time since i have been here (we moved to Excel entirely :( ) i have 2 tables: ID is a key for us. t_AnimalInput ID Animal Color 1 Dog Green 2 Cat White t_AnimalSource ID Animal Color 1 Dog Green 2 Cat Black 3 Mouse Red and now expexted result is...

Hi, looking for a tool which help to transfrom PostgresSQL to AccessSQL. I want to just use powerful access quuery designer from postgres. Thanks for any tips, Best, Jacek

hi Guys, i want to import tables from postgresql into Access using Link tables. How can i do this if table name is something like (in postgres, i can not change it is part of a model): vn-bundle-majax:analytics:1.0.0.TableName This is why that in postgres schema name is...

Hi, i want to somehow see relationships in Access from Postgres. Access can be linked with Postgres and i have for example DDL in Postgres like here: CREATE DATABASE database; CREATE TYPE t_name AS ( first VARCHAR(30), last VARCHAR(60) ); CREATE TABLE telephone_m (...

Hello Guys, i have model where i have composite keys (primary keys - unique ones). And what i need to do is creating relationships between tables. What i will get i will get just flat files with composite keys specified and will have to join them to see only structure in diagram. It is good...

Hi, i would like to ask you Guys do you have method to import DDL structure from from example flat file like CSV and import it to Access? It has to be written in VBA? It is possible to set up relations and so on ? Or not? Please help, Jacek

Hello, i have situation where not all my tables are visible on screen. They just on the left on screen (sometimes Access does this strange thing for me) and i can not bring them back! It is any solution for this? Jacek

Hello, It is possible to check it easily in SQL? Or should i use VBA? I imported tables but somebody added newcolumns which i didnt detect and i goe error via queiries. How to avoid it? Jacek

Hi Guys, i have Excel connected to Access FE linked to MS SQL Server BE. How to do proper security? I mean Excel is connecting to Access database but how to give certain user access to Access but with password? IT is possible? If it is only VBA i will have issue because VBA is easilt...

Hi Guys, i forgot my database access. It is easy to break the pass? What encoding script is used to secure access? Best, Jacek

Hi Guys, I have seperate table not connected to any relationships which i have to just import to Access from csv and update what we currently have. And now what is better? 1. Clear all table record and just replace all (without deleting table). 2. Delete whole table and replace with new 3...

Hi Guys, I have relationships something like here: And also i am using tblVolumes and there i have reference to serverClassID (i am not using relationships here because i have already used them in seperate case as above). Now i got one new table --> tblServerDetails where i have also key...

Hi Guys, i have 2 tables: and : What i want is to get left join between AppVersion and System from TAble2ToJoin and get all matching records but inclusind relation "AnyVersion" to "All". So all versions (4.1,3.1, etc.) should be joined with "All" from Table2Join. Result table should...

Hi Guys, i want to ask you once again about nulls in tables. I created 2 tables: And now i create query to check if records in TempTable exists in Target Table: The result seems to be ok even i have nulls here. When i am joining much more fields, like 15 like that sometimes nulls is not...

Hi Guys, i am using query to update nulls to "Null" string on temp table: UPDATE tblVolumeOSMountOptionsTemp SET OSType = Nz(OSType,"Null"), OSDistro = Nz(OSDistro,"Null"), OSVersion = Nz(OSVersion,"Null"), StorageProtocol = Nz(StorageProtocol,"Null"), ProtocolVersion =...

Hi Guys, i have a table where i have nulls. I want to for each column where i have null use Nz function in order to have result "Null" as string. Problem what i have is that i have to go manually for each column, set up Nz function and it takes a long time. It is the way to automate it...

Hi Guys, i created simple example database to reproduce error with i am facing off. On my form i have Group: Men and Women and on subform i have Names and NumberOfPets: The combobox source is from People.NumberOfPets column. What i want to do is to update current record with the added...

Hi, it is possible to not refer to already created query but to set up combobox values from 1 to 100 inside combobox source row property? Can anybody help? Best, Jacek