Hi all,
Is it possible that i can create my program to an exe look like because i want to protect my program that sell to my customer. If can not how bout just disable the design view of the program.
Thanks you.
Kindly regard,
alex
I need to show two decimal places on a form based on a recordset of a table that has a field - type = double, format = fixed, and decimal number = 2
I need to show 101.00 and 102.00 so if user insert a record, record would have a sequence id of 101.05.
How do I create that field by code? The table is part of a system loop that it changes everytime thats why I have to recreate the table again and again.
I can do the double, I cant do the fixed and decimal number.
Please please help.
Thanks.
NEVER MIND, I FIGURED IT OUT.
Instead of including it with the code, I tweaked how the form displays it.
Thanks.
Hi
Please help me,
I have the form, in this form there is list of value which run query and resulting the report. For example if I have 5 item in list, i have to choose one of then and the query running and the report is print preview.
My question is,
How to export all 5 report to 5 sheet in one excel file.
I know may be the problem in format if I send to excel, but I will fix it in the excel. The most important is, I export the report to excel, each of the report in each of sheet of excel.
Thanks in advance
sorry my english is not good.
I wanted to assign the field "Number of magazine" with special format based on date/time format but showing only year and month in the format: "yyyy-mm".
So in property of this field in format I put yyyy-mm and in input mask I type 0000-00;;-
I also created the form based on the table containing above field and I defined format and input mask for corresponding formant in the same way like at the table.
But if I try to type date for example 2014-01 in text box of the form it comes up with the full date 2014-01-01. Why does it do like this? What do I do incorrectly?
I have a list of dates in the mm/dd/yyyy format and I am looking to get it into the fiscal format of yyyyww. I am able to do this with the datepart and format functions, but I need to make it so that the fiscal month begins in January but the first week starts if there are three or more days in the week. For instance if Jan 1st is a Friday then this stands as the first fiscal week, if it is a Saturday then it does not count as the first week.
datepart and format functions have the Use the first week in the year that has at least 4 days for the firstweekofyear option but I need it where it has at least three to make it work.
I want to format the text using format function. how i format the word apple to "apple" (With Quatation mark).
str = Format(Me.word, xxxx)
I am exporting data from access 2007 to Excel 2007 using VBA code. I have a whole number, which I want displayed as whole number. But after the export, the number is using the 1000's seperator in Excel. So for example if my original number in access table is 12000, it is showing up as 12,000 in the excel file.It has something to do with the NumberFormat property. I have tried doing this but doesn't work.
objSheet.Range("A1:A7").NumberFormat = "General"
We're using Access 2010 on Windows 7.We have a large database design where we send reports as e-mail attachments. We need to change the way the file is automatically created when sent. I goes to snapshot form every time we attach it to an e-mail. How can we get rid of the snapshot .snp file format? How can we change it to pdf or accbd?
View 3 Replies View RelatedI am trying to create a form to enter data in a table. I would like to make it pull in info from a switchboard. If the record already exists I would like it to find it and allow me to edit the info. If the record doesn't exist I would like to be able to add a new record with the data input. What is the best way to accomplish this?
View 1 Replies View RelatedI created a database and I manage to split it into front end and backend. now I'm going to make an EXE of the front end.My question is when I open the front end, I need the database to be empty, and them create a button that will make the user select which project he wants to open (backend).I also need to create a button that will create a new empty backend and save it as a new project.
View 7 Replies View RelatedI'm trying to use Conditional Formatting Options on a Text box called "Date". I'd like that this box become Red if its value is between value1 from Text box "Start Date" and value2 from Text box "End Date" or Green otherwise (in this way the color change dynamically every time I change the values of Text Boxes "Start Date " and "End Date"). How can I do that? What I need to type in the Conditional Formatting Windows?
Is there any other way to do that without using Conditional Formatting?
I really forgot how to do this, how can I change the format of my ID, I have set it up as autonumber and I need to view as
For Example
ACA001
ACA002 etc
The way I have it now is just simple plain numbers 1,2,3,4,5..etc
Thanks.
I have tried various suggestions posted, but still can't seem to get the result I need. I have a field I have to import to a database, SS (Social Security Number). In the database I am exporting from, it is text and does not use leading zeros. In the database I am importing into, it must have leading zeros and be in the format 123-45-6789 as a text field. I have tried input masks, formats, etc but still can't seem to make it work. I do not want to add zeros to fields that have the beginning three digits, or add too many zeros to the fields having two of the three digits. Any help would be appreciated.
View 4 Replies View RelatedI have a query where I extract today's date and time using now() but need the extracted file to display the date/time as YYYY-MM-DD HH:MM:SS
View 4 Replies View RelatedI am having difficulties converting a chart/form to from 97 to 2003.
I keep getting "Undifiend function 'Format' in expression."
The query behind the form is
SELECT (Format([Dated],"MMM 'YY")),Count(*) AS [Count] FROM [apps set up] GROUP BY (Year([Dated])*12 + Month([Dated])-1),(Format([Dated],"MMM 'YY"));
Any ideas why?
After I send the file using RTF format, I open the file, the border line cannot be transfer there. But, the report can show borderline. After transferring, the borderline cannot show.
How can I transfer borderline and the image?
Hi,
I've created a database to keep track of schedules, and have created a report that displays like a calendar.
Similar to Pat's example here
http://www.google.com/url?sa=D&q=http://www.access-programmers.co.uk/forums/showpost.php%3Fp%3D288791%26postcount%3D17
What I would like to do now, is create a DAP that will display in a similar format. But because the report uses subreports, it doesn't just tranfer over.
Does anyone have any ideas on how to create a simlar calendar format, within a DAP?
We want to use this on our intranet, so everyone can see each others schedules, and this is the only thing left I have to do. I just can't seem to get anything to work.
thanks
Chris.
I have a problem with one of my combo box. The format setting of the combo box doesn't change anything to the way I see my data. The row source is based on a query of which the 'data sheet view' shows my field with three decimal number. Whatever setting I change on my combo boxe parameter, the data in the list are always shown with 2 decimals. What can i do to view my data with 3 decimals?
View 13 Replies View RelatedI have this code for an excel file in vba, strDate = Format(Date, "mm-dd-yy") & " " & " at " & Format(Time, "h-mm-ss").
I'm trying to put colons ":" instead of the dashs "-" for the time but I get a debug error, is there any way I can make it work, or am i stuck with dashes. Thanks.
The date format from one of my access tables is as follows:
11051977
9101978
and I need to amend to following formats within my select query:
11/05/1977
09/10/1978
I have tried using formula:
Date of Birth: DateValue(Mid([DOB],7,2) & "/" & Mid([DOB],5,2) & "/" & Mid([DOB],1,4))
that results in an #Error messages
Can anyone help?
Thanks
Does anyone know of a module that will take the results of an Access query and convert them for export into a .iif file that can easily be imported into Quickbooks?
I would imagine that if someone developed something like this, that it would be very useful to any Access developer who creates applications that involve invoicing.
Thanks in advance
SHADOW
Hi All
A simple problem no doubt!
I am trying to convert my Works database into an Access dB (which I have just bought). I cannot find any help on this anywhere?
Any help will be much appreciated
Thanks
Paul
I have a database that tracks client contact and I have a report that I want to print that shows all the contact a rep has had with the client. I enter the start and end dates I want and the reps name and when I run the report its listed in date order so I might have Jane Doe - 10/1/06 then Jack Jones - 10/2/06 then Jane Doe - 10/3/06 (again) I want Jane Doe - 10/1/06 , 10/3/06 then Jack Jones - 10/2/06 and so on. I'm pulling the information from a query and when I run the query it displays it properly with all the Jane Doe records together but when I run the report is sorted by date. I am in the process of redoing this database and it's on the new one this happens on the old database it works like it's supposed to when I print/view the report.Any thoughts on where to check?Thanks,Rick
View 7 Replies View RelatedHello
Can someone help format the date correctly? I'm currently linking a flat file in access and then creating a table afterwards. The date comes in the following format below:
i.e. 30102006 - txt type
I wanted the date to look like - mm/dd/yy. Thanks for the help.
i use the format function to display month, here is the code below:
Format(MthInput, "mmmm")
however, whatever MthInput value is used say 1,2,3...
the month display will always either be december or january why is this so?
i want it to be 1 -> january
2 -> feburary
:
:
12 -> december
did i use the format function correctly?
I have a date field in my table and my computer date is set as a custom long date, if I enter 24/2/07 in my date field when I press enter and move to the next field it is displayed as Saturday 24 February 2007 but when I select the date field again it reverts back to 24/2/07. I include the date field in a merge with a word document and would like the date displayed as Saturday 24 February 2007, but the merge is displayed as 24/2/07. Can anyone help with how to merge the date as Saturday 24 February 2007?
View 4 Replies View Related