Search results

I Think This Should Work. I think that this should work.... what it does is lists the "Reports " from the SysObject Table. Make A List Box And Call It Something like "ReportList" Enter This Code Into The Row Source: SELECT Name FROM msysobjects WHERE (((msysobjects.Type)=-32764)); To select...

I Think This Should Work. I think that this should work.... what it does is lists the "Reports " from the SysObject Table. Make A List Box And Call It Something like "ReportList" Enter This Code Into The Row Source: SELECT Name FROM msysobjects WHERE (((msysobjects.Type)=-32764)); To select...

I Think This Should Work. I think that this should work.... what it does is lists the "Reports " from the SysObject Table. Make A List Box And Call It Something like "ReportList" Enter This Code Into The Row Source: SELECT Name FROM msysobjects WHERE (((msysobjects.Type)=-32764)); To select...

I Think This Should Work. I think that this should work.... what it does is lists the "Reports " from the SysObject Table. Make A List Box And Call It Something like "ReportList" Enter This Code Into The Row Source: SELECT Name FROM msysobjects WHERE (((msysobjects.Type)=-32764)); To select...

HI, I am having a problem with all of my comment fields showing up as Japanese and I need to get some reports printed... Does anyone know how or why this would or could happen? I have checked the tables but they are normal. When you query the tables is when the comments start to mess up...

Hi, I need to create a query that will parse a word and separate it into a list of letters. I have had a go myself but am unable to do it... does anyone else know what to do? Thanks.

Example This is an example database which you can use to get this function... I hope it helps.

Hi I am having trouble trying to find some code that lists the fields in a selected table (which is in a list box its self.) I can list the tables but what I really need is for the table to update a list box with its own individual fields. does anyone know what I mean and can you help?

Hi, I have been trying to list all of the objects in my database in a single form. I have come across this piece of code which lists the reports, can anyone surgest how I can change it to wiew tables? SELECT Name FROM msysobjects WHERE (((msysobjects.Type)=-32764));

Thanks... it helped alot

Hi, I have been trying to get an image to open from its location.... but it keeps trying to open "C:\C:\example.bmp" instead of "C:\example.bmp" does anyone know how to take out the first directory location tag automatically? Any help will be great! Thanks.

Ill check to see if Keiths will work first and then I will paste the code

Hi, The Problem that im getting is that when I query select a yes/no field in a table the results return TRUE and FALSE, even when the criteria states Yes. does anyone know whats going on with it. I know it isnt me as I have had my collegues check it over and they are all confused as well...

Example Here is an example database which user a calendar format that has that function Its a bit confusing, but you can take what you want or need from it and then delete it. http://www.candace-tripp.com/download/MiniCalendar.zip

I can get aroun the shift key as I have some code that disables it!

Hi, Here is a good one thats got me stuck for ages. I have made an email facility in my database and I have set the message box as a memo for the Unlimited Characters. There are a number of templates that the user can select but I cannot get the simple text to show formatting (as in rich text...

I have looked at it from this angle but in my circumstances it won’t be applicable unfortunately. Thank you anyway.

A little help Hi, Here is a basic example of a password script. You want to make a new form and call it something like frmPassword. On the form you want to make a text box and call that "Password". Also you want to make the input mask for the box a password (Text Box Properties). Make a...

Hi, I have been working on some database protection, in which I am trying stop my tables from being able to be imported from other databases. Does anyone know where I should start or even if it is at all possible?

Thanks, I'll give it a go!