Search results

any help?

I still did not rename my fields, waiting for a reply?

Re: lookup question ("lookup column" or "type in the values that I want") help anyone ?

Re: lookup question ("lookup column" or "type in the values that I want") here I created quick example: lookup_problem.zip See the table tbl_opkodas with two joined to two tables. I would like to have only one but it seems impossible. I know about table level lookup problem but my real dabase...

Thanks, can I rename them without impact on my database like integrity and that all queries and reports will still work?

Re: lookup question ("lookup column" or "type in the values that I want") Well I have a table where information for lookup purposes will be stores it had PK autonumber and 2 fields one for lookup code, another for description tbl_opkodas PK ID opkodas text aprasymas text Then I have other 2...

for example just now access generated this nonsense when you use visual editor you get this: SELECT tbl_opkodas.ID, tbl_opkodas.opkodas, tbl_opkodas.aprasymas FROM tbl_opkodas ORDER BY tbl_opkodas.[opkodas]; I had to change it to SELECT [tbl_opkodas].ID, [tbl_opkodas].[opkodas]...

BTW not sure why sometimes access gets this: SELECT [tbl_kpo].[ID], [tbl_kpo].[Kasos pajamu orderis Nr:] FROM tbl_kpo ORDER BY [ID] DESC; sometimes: SELECT [tbl_kpo].ID, [tbl_kpo].[Kasos pajamu orderis Nr:] FROM tbl_kpo ORDER BY [ID] DESC; I think I should include the brackets? I read...

Thanks for reply. It seems access generates code like line 1 SELECT [tbl_bpo].[ID], [tbl_bpo].[Banko pajamu orderis Nr:] FROM tbl_bpo ORDER BY [ID] DESC; if you just create lookup, then if you like me created first to sort by same field you use in lookup itself and another to sort by ID. The...

IT isn't easy to call row2, I get only row 1. BTW I need this table to hold other info too so while I can include certain columns in certain reports and call row1 I can't call row2. I link table -> report no queries used here.

Hi, I have created some lookups and for one access made syntax like this SELECT [tbl_bpo].[ID], [tbl_bpo].[Banko pajamu orderis Nr:] FROM tbl_bpo ORDER BY [ID] DESC; For another SELECT tbl_kpo.ID, tbl_kpo.[Kasos pajamu orderis Nr:], tbl_kpo.[ID] FROM tbl_kpo ORDER BY tbl_kpo.[ID] DESC; Both...

What do you mean more than one row? I now have a table tbl_dataset. In design view when you enter data in rows later when you fill the table they become columns. So now I have in design view: Version Made by updated In table view I have: Version Made by updated version 2.0...

Well I tried to create a table then use it as for my reports, as you said if I need more data it can be very hard to update as data is stored horizontal and not vertical.

Hi, I need to store some infomration on my reports like version number, etc. This need to be changed at once on many reports. I was thinking to store it in a table, but how do call it?

lookup question ("lookup column" or "type in the values that I want") I know lookup is bad in access but I need to choose from 2 scenario: 1.I want the lookup column to look up the values in a table or query 2.I will type in the values that I want. I need to store some text that is rarely...

XP service pack 3 fixed my boot lag problem :)

Well my lag problem started a few months back and I don't remember any exact changes I made. I do have many icons and files on desktop :eek: But my GFX cart Nvidia FX5700 should be able to handle it no? I now disabled the auto login and click my name icon and enter password manually. No lag...

I used Bootvis to try check where the problem is. I attached my BIN file could somebody with knowledge please help me. http://rapidshare.com/files/122498089/boot_lag.rar.html

After reading on another forum that I need to create another user account to test if my own is currupt. I created another user account and rebooted my pc. I clicked on the new user account and login was instant. Then I rebooted again and clicked my user acount the login was working ok too...

WinXP SP2, it's experiencing a boot lag that is 1 minute long. The boot lag occurs when I see Logon screen "Loading your personal settings" The next thing I see is my desktop wallpaper, it just sits there for ~1 minute. Then the desktop icons appears and tray applications are loaded. To...