Search results

Hello, need some help please I know it's possible to send a form to an email to be filled and sent back to you. I need to know how can I set restrictions on the data the recipient is allowed to enter in the form. For example, if I want the same data restrictions on access to be implemented on...

Hey If I have one column, and I want to split the numbers into 2 columns such that these 2 columns can't have the same values at the same row.

Ok, this is it SELECT [P2P MW Link Information].SP_ID, [P2P MW Link Information].Link_ID, Sites.Site_ID AS Site1_ID, Sites.Site_ID AS Site2_ID, Antenna.Ant_ID AS Ant1_ID, Antenna.Ant_ID AS Ant2_ID, Sites.Site_Latitude AS Site1_Latitude, Sites.Site_Longitude AS Site1_Longitude...

I've tried that before, it wouldnt work? do u have an email i can send it to u to look at it, coz its driving me crazy,

I changed the name, but the data is not appearing in the query. see, what I'm trying to do is this: I have a table (location ID, location latitude) another table (link ID, path length) I want to create a query such that every 2 locations are connected with 1 link (location1ID, location2ID...

Hey all, Can I create a query from a table and put 2 columns with the same name or do I have to use "AS" to keep one column same name and the second give it an alias name but it will remain connected to the same column? Thank you

Yeah, I just tried this one, but with 9999,9999 instead of 0s. It's working this way, I just wish these things could be a bit more flexible. I was wondering, if we were using GUI, will the text field also appear as the input mask output? Like "0"'s instead of blank positions?

Oh, but what if I don't want the digits to have a fixed lenght. When I try it, it only allows me to enter exactly 4 digits. How can I change that, I want the suer to enetr any number of digit.

OH GOD, it worked, thank you thank you MrQ,

Thank you guyz, both, you've been really helpful.

It's very simple, ihave a table and a column for the frequency band that I want to format in the design view. So, in the design view, I can chose what data type I want to enter (text, number..) I just want a data type format which is not there, but it's really close to the date format...

Hey MrQ I did have 2 tables at first, but then I thought it's better to just merge them all, i mean for the users. Anyways I think I'll just remove all indexes and not set a primary key. because it's not even accepting a primary key. Thanks alot,

Thanks, but you see, the form is an output, it's just a readonly for displaying the queries. That's not what I want, isn't there a way I can make my own data type. What do ""attachment" and "OLE object mean in the data type combo box in access?

thank you, the alaska thing was just an example, i am considering i have no clue what the user would like to filter. So it also wouldn't be workable that I create a drop down box for every category, because i really don't know what the suer would want. But this filter option, is there a...

sorry, forgot to attach it first time, it's attached now

Ok, so assume I create 2 columns one for start freq and another for end freq. So how can I create a form to display only 2 columns : antenna ID and Frequency band (merging the values from the start and end columns separated by a column) I see what you did, but I don't know HOW TO do it, I mean...

The problem is in the Subservices Table, the database couldnt be uploaded,so i attached a screenshot. another thing is I don't want the columns to ordered in a way that the serviceid and subserviceid are the first 2 columns, i keep on moving them but access just gets them back in the other order.

Oh trust, I'm shouting alright! You see, the column is "frequency band (MHz)" So normally, i want the start frequency and the end frequency separated by a comma, I don't want to have 2 columns one for the start frequency and another for the end frequency. But I think it is possible since we can...

I'm sorry I meant they can't have either same subservice ID or subservice name

Thanks alot, but I still don't get one thing, you're saying I can create forms that users can see and enter values in and so on. So does that mean I have to create forms for every possible combination of columns just incase the user wants to view specified columns? THAT is a MESS, I mean that...